Bplus/Balance_pkg

--------------------------------------------------------
--  File created - Thursday-November-27-2025   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Package BALANCE_PKG
--------------------------------------------------------

  CREATE OR REPLACE EDITIONABLE PACKAGE "BALANCE_PKG" IS
TYPE refcursor IS REF CURSOR;
PROCEDURE PARAMS_GET_LIST
(
  v_type in varchar2,
  P_RESULT OUT refcursor
);
 PROCEDURE pro_get_reload
(
  v_prId in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE pro_get_update
(
  v_prId in varchar2,
  v_user in varchar2,
  P_RESULT OUT refcursor
);

PROCEDURE COM_GET
(
  v_id in varchar2,
  v_users in varchar2,

   v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

  P_RESULT OUT refcursor
);
PROCEDURE COM_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,
V_PHONE in varchar2,
V_EMAIL in varchar2,
V_ADDRESS in varchar2,
V_DESCRIPTION in nvarchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
P_RESULT OUT refcursor
);
PROCEDURE COM_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_PHONE in varchar2,
V_EMAIL in varchar2,
V_ADDRESS in varchar2,
V_DESCRIPTION in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
P_RESULT OUT refcursor
);

PROCEDURE BL_GET
(
  v_id in varchar2,
  v_users in varchar2,

  v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,
   v_isActive in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE BL_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,
V_MIN in varchar2,
V_MAX in varchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
P_RESULT OUT refcursor
);
PROCEDURE BL_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_MIN in varchar2,
V_MAX in varchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
P_RESULT OUT refcursor
);
PROCEDURE EP_GET
(
  v_id in varchar2,
  v_users in varchar2,

  v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,
  v_isActive in varchar2,

  P_RESULT OUT refcursor
);
PROCEDURE EP_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,
V_TOTAL_DAY_USE in varchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_MIN in varchar2,
V_MAX in varchar2,
P_RESULT OUT refcursor
);
PROCEDURE EP_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_TOTAL_DAY_USE in varchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
V_MIN in varchar2,
V_MAX in varchar2,
P_RESULT OUT refcursor
);
PROCEDURE PAM_GET
(
  v_id in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE PAM_INSERT
(

V_CODE in varchar2,
V_SVALUES in varchar2,
V_NOTE in nvarchar2,
V_STATUS in varchar2,
V_CODE_GROUP in varchar2,
V_DISPLAY0 in nvarchar2,
V_DISPLAY1 in nvarchar2,
V_DISPLAY2 in nvarchar2,
V_DISPLAY3 in nvarchar2,
V_DISPLAY4 in nvarchar2,
V_DISPLAY5 in nvarchar2,
V_GAME_ID in varchar2,
V_CHANNEL in varchar2,
V_USERS in varchar2,
P_RESULT OUT refcursor
) ;
PROCEDURE PAM_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_SVALUES in varchar2,
V_NOTE in nvarchar2,
V_STATUS in varchar2,
V_CODE_GROUP in varchar2,
V_DISPLAY0 in nvarchar2,
V_DISPLAY1 in nvarchar2,
V_DISPLAY2 in nvarchar2,
V_DISPLAY3 in nvarchar2,
V_DISPLAY4 in nvarchar2,
V_DISPLAY5 in nvarchar2,
V_GAME_ID in varchar2,
V_CHANNEL in varchar2,
V_USERS in varchar2,
V_TYPE in varchar2,

P_RESULT OUT refcursor
);
PROCEDURE SVGROUP_GET
(
  v_id in varchar2,
  v_users in varchar2,

  P_RESULT OUT refcursor
);
PROCEDURE SV_GET
(
  v_id in varchar2,
  v_users in varchar2,

  v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

  v_isActive in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE SV_INSERT
(

      V_CODE in nvarchar2,
      V_NAME in nvarchar2,
      V_DESCRIPTION in nvarchar2,
      V_SHORT_CODE in nvarchar2,
      V_COMMAND_REGISTER in nvarchar2,
      V_CONTENT_EN in nvarchar2,
      V_CONTENT_FR in nvarchar2,
      V_CONTENT_LC in nvarchar2,
      V_NOTE in nvarchar2,
      V_COMPANY_ID in nvarchar2,


      V_USERS in nvarchar2,

      V_USSD_MSG_REGISTER_SUC in nvarchar2,
      V_USSD_MSG_REGISTER_FAIL in nvarchar2,
      V_USSD_CONFIRM in nvarchar2,

      V_SERVICE_GROUP_ID in nvarchar2,
      V_API_SERVICE_ID in nvarchar2,
      v_isMyservice in nvarchar2,
      P_RESULT OUT refcursor
);
PROCEDURE SV_UPDATE
(
      V_ID in varchar2,

      V_CODE in nvarchar2,
      V_NAME in nvarchar2,
      V_DESCRIPTION in nvarchar2,
      V_SHORT_CODE in nvarchar2,
      V_COMMAND_REGISTER in nvarchar2,
      V_CONTENT_EN in nvarchar2,
      V_CONTENT_FR in nvarchar2,
      V_CONTENT_LC in nvarchar2,
      V_NOTE in nvarchar2,
      V_COMPANY_ID in nvarchar2,

      V_USERS in nvarchar2,
      V_TYPE in varchar2,
      V_USSD_MSG_REGISTER_SUC in nvarchar2,
      V_USSD_MSG_REGISTER_FAIL in nvarchar2,
      V_USSD_CONFIRM in nvarchar2,  

      V_SERVICE_GROUP_ID in nvarchar2,
      V_API_SERVICE_ID in nvarchar2,
      v_isMyservice in nvarchar2,
      P_RESULT OUT refcursor
);
/*
PROCEDURE SVADD_GET
(
  v_id in varchar2,
  v_users in varchar2,
  v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE SVADD_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,

V_ADD_TYPE in varchar2,
V_NUMBER_DISPLAY in varchar2,
V_PRIORITY in varchar2,
V_SERVICE_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
P_RESULT OUT refcursor
);
PROCEDURE SVADD_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_ADD_TYPE in varchar2,
V_NUMBER_DISPLAY in varchar2,
V_PRIORITY in varchar2,
V_SERVICE_ID in varchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
P_RESULT OUT refcursor
);
*/
PROCEDURE CAM_GET
(
  v_id in varchar2,
  v_users in varchar2,

   v_name in varchar2,
  v_code in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,
  v_status in varchar2,
   v_isDefault in varchar2,
   v_isMyservice in varchar2,
  P_RESULT OUT refcursor
);

 PROCEDURE CAM_GET_CALENDAR
(

  v_users in varchar2,

  v_fromDate in varchar2,
  v_toDate in varchar2,
v_status in varchar2,
  P_RESULT OUT refcursor
);

 PROCEDURE CAM_GET_REPORT_TOTAL
(

  v_users in varchar2,

  v_fromDate in varchar2,
  v_toDate in varchar2,
  v_status in varchar2,
  v_isDefault in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE CAM_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,

V_FROM_DATE in varchar2,
V_TO_DATE in varchar2,
V_FROM_HOUR in varchar2,
V_TO_HOUR in varchar2,
V_RULE_ADD in varchar2,
V_PRIORITY in varchar2,
V_BALANCE_ID in varchar2,
V_EXPIRE_DATE_ID in varchar2,
V_STATUS in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_DISPLAY in nvarchar2,
V_ADD_TYPE in nvarchar2,
V_TITLE in nvarchar2,
V_DEFAULT in nvarchar2,
V_MYSERVICE in nvarchar2,

P_RESULT OUT refcursor
);
PROCEDURE CAM_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,

V_FROM_DATE in varchar2,
V_TO_DATE in varchar2,
V_FROM_HOUR in varchar2,
V_TO_HOUR in varchar2,
V_RULE_ADD in varchar2,
V_PRIORITY in varchar2,
V_BALANCE_ID in varchar2,
V_EXPIRE_DATE_ID in varchar2,
V_STATUS in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
V_DISPLAY in nvarchar2,
V_ADD_TYPE in nvarchar2,
V_TITLE in nvarchar2,
V_DEFAULT in nvarchar2,
V_MYSERVICE in nvarchar2,
P_RESULT OUT refcursor
);
PROCEDURE CAM_COPPY
(
  v_id in varchar2,

  P_RESULT OUT refcursor
);
PROCEDURE CAMADD_GET
(
  v_id in varchar2,
  v_users in varchar2,

  v_campaignId varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,


  P_RESULT OUT refcursor
);
PROCEDURE CAMADD_INSERT
(

V_CAMPAING_ID in varchar2,
V_SERVICE_ADD_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_USSD_DIS in nvarchar2,
V_KEY_REGIS in nvarchar2,
V_MSG_CONFIRM in nvarchar2,

P_RESULT OUT refcursor
);
PROCEDURE CAMADD_UPDATE
(
V_ID in varchar2,
V_CAMPAING_ID in varchar2,
V_SERVICE_ADD_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
V_USSD_DIS in nvarchar2,
V_KEY_REGIS in nvarchar2,
V_MSG_CONFIRM in nvarchar2,

P_RESULT OUT refcursor
);

PROCEDURE CAM_SUB_GET
(
  v_id in varchar2,
  v_users in varchar2,


  v_campaignId in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

   v_channel in varchar2,
  v_language in varchar2,
  P_RESULT OUT refcursor
) ;
PROCEDURE CAM_SUB_INSERT
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
  v_channel in varchar2,
  v_language in varchar2,

P_RESULT OUT refcursor
);
PROCEDURE CAM_SUB_UPDATE
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,

v_channel in varchar2,
  v_language in varchar2,
  V_ID in varchar2,
  V_TYPE in varchar2, --1=delete,2=update
P_RESULT OUT refcursor
);

PROCEDURE CAM_BAL_GET
(
  v_id in varchar2,
  v_users in varchar2,


  v_campaignId in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

   v_channel in varchar2,
  v_language in varchar2,
  P_RESULT OUT refcursor
);

PROCEDURE CAM_BAL_INSERT
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
  v_channel in varchar2,
  v_language in varchar2,

P_RESULT OUT refcursor
) ;
PROCEDURE CAM_BAL_UPDATE
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,

v_channel in varchar2,
  v_language in varchar2,
  V_ID in varchar2,
  V_TYPE in varchar2, --1=delete,2=update
P_RESULT OUT refcursor
) ;


PROCEDURE CAM_EXP_GET
(
  v_id in varchar2,
  v_users in varchar2,


  v_campaignId in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

   v_channel in varchar2,
  v_language in varchar2,
  P_RESULT OUT refcursor
);

PROCEDURE CAM_EXP_INSERT
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
  v_channel in varchar2,
  v_language in varchar2,

P_RESULT OUT refcursor
) ;
PROCEDURE CAM_EXP_UPDATE
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,

v_channel in varchar2,
  v_language in varchar2,
  V_ID in varchar2,
  V_TYPE in varchar2, --1=delete,2=update
P_RESULT OUT refcursor
) ;




PROCEDURE CAM_SC_GET
(
  v_id in varchar2,
  v_users in varchar2,


  v_campaignId in varchar2,
  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

   v_channel in varchar2,
  v_language in varchar2,
  P_RESULT OUT refcursor
);

PROCEDURE CAM_SC_INSERT
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,
  v_channel in varchar2,
  v_language in varchar2,

P_RESULT OUT refcursor
) ;
PROCEDURE CAM_SC_UPDATE
(

V_CAMPAING_ID in varchar2,
V_REF_ID in varchar2,

V_NOTE in nvarchar2,
V_USERS in nvarchar2,

v_channel in varchar2,
  v_language in varchar2,
  V_ID in varchar2,
  V_TYPE in varchar2, --1=delete,2=update
P_RESULT OUT refcursor
) ;



PROCEDURE ERR_CODE_GET_LIST
(
  v_type in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE ADMIN_LOGIN
(
  v_user in nvarchar2,
  v_pass in nvarchar2,

  P_RESULT OUT refcursor
);
PROCEDURE ADMIN_GET_ROLE
(
  v_role in nvarchar2,

  P_RESULT OUT refcursor
);
PROCEDURE USERS_GET
(
  v_id in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE USERS_INSERT
(

V_USERNAME in varchar2,
V_PASSWORD in varchar2,
V_ROLE in nvarchar2,
V_COUNTRY_CODE in varchar2,
V_IS_LOCK in varchar2,
V_TOTAL_FALSE in nvarchar2,
V_TIME_LOCK in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in varchar2,
P_RESULT OUT refcursor
);
PROCEDURE USERS_UPDATE
(
V_ID in varchar2,
V_USERNAME in varchar2,
V_PASSWORD in varchar2,
V_ROLE in nvarchar2,
V_COUNTRY_CODE in varchar2,
V_IS_LOCK in varchar2,
V_TOTAL_FALSE in nvarchar2,
V_TIME_LOCK in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in varchar2,
V_TYPE in varchar2,

P_RESULT OUT refcursor
);

 PROCEDURE TMP_GET
(
  v_id in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE TMP_INSERT
(

V_NAME in varchar2,
V_SV in varchar2,
V_MSG in nvarchar2,
V_FD in varchar2,
V_TD in varchar2,
V_PC in nvarchar2,
V_ADD_TYPE nvarchar2,
V_USERS in varchar2,
P_RESULT OUT refcursor
) ;
PROCEDURE TMP_UPDATE
(
V_ID in varchar2,
V_NAME in varchar2,
V_SV in varchar2,
V_MSG in nvarchar2,
V_FD in varchar2,
V_TD in varchar2,
V_PC in nvarchar2,
V_ADD_TYPE nvarchar2,
V_USERS in varchar2,
V_TYPE in varchar2,

P_RESULT OUT refcursor
) ;
PROCEDURE GET_DATA
(
  v_type in varchar2,
  P_RESULT OUT refcursor
) ;

PROCEDURE BLACK_GET
(
  v_msisdn in varchar2,
  v_type in varchar2, --1= Nhan vien,2=Blacklist all,3=blacklist theo dich vu,4=whitelist theo dich vu
  v_sv_id in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE BLACK_INSERT
(

  v_msisdn in varchar2,
  v_type in varchar2, --1= Nhan vien,2=Blacklist all,3=blacklist theo dich vu,4=whitelist theo dich vu
  v_sv_id in varchar2,
  v_action in varchar2, --1: insert, 2=delete
  v_users in varchar2
);

PROCEDURE CORE_INSERT_USSD
(
  v_msisdn in varchar2,  
  v_message in nvarchar2,
  v_requestType in nvarchar2,
  v_service in nvarchar2,
  v_reqeustId in nvarchar2,
  v_camIsDefault in nvarchar2,
  v_camType in nvarchar2,
  v_camService1 in nvarchar2,
  v_camService2 in nvarchar2
);

PROCEDURE CORE_BLACKLIST_GET
(
  v_type in varchar2,  --1= Nhan vien,2=Blacklist all
  P_RESULT OUT refcursor
);
PROCEDURE CORE_UPDATE_RELOAD
(
  v_type in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE GET_CAMPAIGN_RUNNING
(
  v_type in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE GET_SERVICE_OF_CAM
(
  v_campaignId in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE GET_SERVICE_OF_CAM_NGAM
(
  v_campaignId in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE CORE_INSERT_REGISTER
(
  v_msisdn in varchar2,  
  v_campaign_add_id in nvarchar2,
  v_campaign_id in nvarchar2,
  v_service_id in nvarchar2,
  v_request_id in nvarchar2,
  v_key_press in nvarchar2,
  v_err_code in nvarchar2,
  v_err_msg in nvarchar2,
  v_ussd_request in nvarchar2,
  P_RESULT OUT refcursor
)



;
PROCEDURE GET_CAMPAIGN_NGAM_RUNNING
(
  v_type in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE JOB_RESET_DAY;
PROCEDURE JOB_CHANGE_CAMPAIGN;
PROCEDURE GET_CAMPAIGN_NGAM_PLS_RUNNING
(
  v_type in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE GET_SERVICE_OF_CAM_NGAM_PLS
(
  v_campaignId in varchar2,  --Hien tai ko su dung

  P_RESULT OUT refcursor
);
PROCEDURE REPORT_BY_CAMPAIGN
(
  v_users in varchar2,
  v_status in varchar2,
  v_FROMDATE in varchar2,
  v_TODATE in varchar2,
  P_RESULT OUT refcursor
);

 PROCEDURE LIST_SUB_FILE_GET
(
  v_id in varchar2,
  v_users in varchar2,
  V_list_sub_id in varchar2, 
  v_name in varchar2,
  v_code in varchar2,

  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,

  P_RESULT OUT refcursor
);
PROCEDURE LIST_SUB_FILE_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_LIST_SUB_ID in nvarchar2,
V_FILE_ID in nvarchar2,
V_FILE_NAME in nvarchar2,

P_RESULT OUT refcursor
);
PROCEDURE LIST_SUB_FILE_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_LIST_SUB_ID in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
V_STATUS in varchar2,
P_RESULT OUT refcursor
);
PROCEDURE LIST_SUB_GET
(
  v_id in varchar2,
  v_users in varchar2,
  V_sub_type in varchar2, --1=black,2=white
  v_name in varchar2,
  v_code in varchar2,

  v_fromDate in varchar2,
  v_toDate in varchar2,

  v_order in varchar2 , --0= tang dan theo ID ticket,1= giam dan theo Id ticket
  v_rowsOnPage in varchar2,
  v_seqPage in varchar2,
  v_isActive in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE LIST_SUB_INSERT
(

V_CODE in varchar2,
V_NAME in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,

V_SUB_TYPE in nvarchar2, --1=black list, 2= white list


P_RESULT OUT refcursor
);
PROCEDURE LIST_SUB_UPDATE
(
V_ID in varchar2,
V_CODE in varchar2,
V_NAME in nvarchar2,
V_SUB_TYPE in nvarchar2,
V_NOTE in nvarchar2,
V_USERS in nvarchar2,
V_TYPE in varchar2,
V_STATUS in varchar2,
P_RESULT OUT refcursor
);
 PROCEDURE IMPORT_GET_FILE
(
  v_type in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE IMPORT_FINSH_FILE
(
  v_uload_id in varchar2,
  v_uload_detail_id in varchar2,
  v_total_row in varchar2,
  v_total_row_false in varchar2,

  P_RESULT OUT refcursor
) ;
 PROCEDURE IMPORT_FINSH_ALL_FILE
(
  v_uload_id in varchar2,

  P_RESULT OUT refcursor
) ;
  PROCEDURE IMPORT_INSERT
(
  v_upload_id in varchar2, 
  v_upload_detail_id in varchar2,
  v_type in varchar2, --ko su dung
  v_ticket in varchar2
);
PROCEDURE LOG_INSERT
(
  v_reqeust in varchar2, 
  v_biz_id in varchar2,
  v_type in varchar2, --1=blacklust,2=whitelist,3=nhan vien
  v_key in varchar2,
  v_contnet in varchar2,
  v_errCode in varchar2

) ;
PROCEDURE CHANGE_STATUS
(
  v_type in varchar2,
  v_id in varchar2,
  v_status in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
);
PROCEDURE SORT_CODE_GET_LIST
(
  v_type in varchar2,
  v_users in varchar2,
  P_RESULT OUT refcursor
) ;



 FUNCTION GET_SERVICE_CHOICE
(
  v_campaign_id in varchar2, 
  v_keypress in varchar2

) return number;

END;

/