-------------------------------------------------------- -- 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; /