APPS.IBY_UPG_PPP_PKG dependencies on IBY_SYS_PMT_PROFILES_B

Line 762: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;

758: ) is
759:
760:
761: l_jenl_eft_reporting_limit NUMBER;
762: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
763:
764: TYPE t_sys_profile_code IS TABLE OF
765: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE
766: INDEX BY BINARY_INTEGER;

Line 765: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE

761: l_jenl_eft_reporting_limit NUMBER;
762: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
763:
764: TYPE t_sys_profile_code IS TABLE OF
765: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE
766: INDEX BY BINARY_INTEGER;
767:
768: l_sys_profile_code_tab t_sys_profile_code;
769:

Line 772: cursor get_sys_prof_code(X_SYSTEM_PROFILE_CODE IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE, l_jenl_eft_reporting_limit NUMBER)

768: l_sys_profile_code_tab t_sys_profile_code;
769:
770:
771:
772: cursor get_sys_prof_code(X_SYSTEM_PROFILE_CODE IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE, l_jenl_eft_reporting_limit NUMBER)
773: IS
774: select system_profile_code
775: from
776: (SELECT DISTINCT(decode(sfgdf.org_id,

Line 1058: update iby_sys_pmt_profiles_b set

1054: FOR i IN l_sys_profile_code_tab.FIRST .. l_sys_profile_code_tab.LAST LOOP
1055:
1056: --kp_msg('Inside the loop for i=' || i|| '; value of sys_prof_code =' ||l_sys_profile_code_tab(i));
1057:
1058: update iby_sys_pmt_profiles_b set
1059: payment_format_code = X_PAYMENT_FORMAT_CODE,
1060: print_instruction_immed_flag = X_PRINT_INSTRUCTION_IMMED_FLAG,
1061: processing_type = X_PROCESSING_TYPE,
1062: mark_complete_event = X_MARK_COMPLETE_EVENT,

Line 1103: -- kp_msg('The updation of iby_sys_pmt_profiles_b tables has been done successfully');

1099: if (sql%notfound) then
1100: raise no_data_found;
1101: end if;
1102:
1103: -- kp_msg('The updation of iby_sys_pmt_profiles_b tables has been done successfully');
1104:
1105: update IBY_PMT_CREATION_RULES set
1106: group_by_delivery_channel = X_PMT_GROUP_BY_DELIVERY_CHANNE,
1107: group_by_remittance_message = X_PMT_GROUP_BY_REMITTANCE_MES,