APPS.IBY_UPG_PPP_PKG dependencies on IBY_SYS_PMT_PROFILES_B

Line 324: /* AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_b');

320: raise no_data_found;
321: end if;
322: close c;
323: -- New for Online Patching
324: /* AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_b');
325: AD_ZD_SEED.PREPARE('iby_sys_pmt_profiles_tl');
326: AD_ZD_SEED.PREPARE('iby_acct_pmt_profiles_b');
327: AD_ZD_SEED.PREPARE('iby_acct_pmt_profiles_tl');
328: AD_ZD_SEED.PREPARE('iby_applicable_pmt_profs');

Line 777: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;

773: ) is
774:
775:
776: l_jenl_eft_reporting_limit NUMBER;
777: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
778:
779: TYPE t_sys_profile_code IS TABLE OF
780: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE
781: INDEX BY BINARY_INTEGER;

Line 780: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE

776: l_jenl_eft_reporting_limit NUMBER;
777: l_system_profile_code IBY_SYS_PMT_PROFILES_B.SYSTEM_PROFILE_CODE%TYPE;
778:
779: TYPE t_sys_profile_code IS TABLE OF
780: IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE
781: INDEX BY BINARY_INTEGER;
782:
783: l_sys_profile_code_tab t_sys_profile_code;
784: l_sys_profile_code_tab_cnt number;

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

784: l_sys_profile_code_tab_cnt number;
785:
786:
787:
788: cursor get_sys_prof_code(X_SYSTEM_PROFILE_CODE IBY_SYS_PMT_PROFILES_B.system_profile_code%TYPE, l_jenl_eft_reporting_limit NUMBER)
789: IS
790: select system_profile_code
791: from
792: (SELECT DISTINCT(decode(sfgdf.org_id,

Line 1078: update iby_sys_pmt_profiles_b set

1074: FOR i IN l_sys_profile_code_tab.FIRST .. l_sys_profile_code_tab.LAST LOOP
1075:
1076: --kp_msg('Inside the loop for i=' || i|| '; value of sys_prof_code =' ||l_sys_profile_code_tab(i));
1077:
1078: update iby_sys_pmt_profiles_b set
1079: payment_format_code = X_PAYMENT_FORMAT_CODE,
1080: print_instruction_immed_flag = X_PRINT_INSTRUCTION_IMMED_FLAG,
1081: processing_type = X_PROCESSING_TYPE,
1082: mark_complete_event = X_MARK_COMPLETE_EVENT,

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

1121: /*if (sql%notfound) then
1122: raise no_data_found;
1123: end if;*/
1124:
1125: -- kp_msg('The updation of iby_sys_pmt_profiles_b tables has been done successfully');
1126:
1127: update IBY_PMT_CREATION_RULES set
1128: group_by_delivery_channel = X_PMT_GROUP_BY_DELIVERY_CHANNE,
1129: group_by_remittance_message = X_PMT_GROUP_BY_REMITTANCE_MES,

Line 1794: INTO iby_sys_pmt_profiles_b

1790: ---------------------------------------------------------------------------
1791: BEGIN
1792: INSERT ALL
1793: WHEN create_header = 1 THEN
1794: INTO iby_sys_pmt_profiles_b
1795: (
1796: system_profile_code,
1797: payment_format_code,
1798: print_instruction_immed_flag,

Line 2784: FROM iby_sys_pmt_profiles_b spp);

2780: AND ipf.format_type_code = 'OUTBOUND_PAYMENT_INSTRUCTION'
2781: AND ppp.bep_suffix = bep.suffix(+)
2782: AND bep.bepid = key.bepid(+)) i
2783: WHERE i.check_format_id NOT IN (SELECT spp.system_profile_code
2784: FROM iby_sys_pmt_profiles_b spp);
2785: EXCEPTION
2786: WHEN others THEN NULL;
2787: END;
2788:

Line 3029: iby_sys_pmt_profiles_b ppp,

3025: apm.last_update_date,
3026: apm.last_update_login,
3027: apm.object_version_number
3028: FROM iby_applicable_pmt_profs apm,
3029: iby_sys_pmt_profiles_b ppp,
3030: iby_payment_methods_b pm
3031: WHERE ppp.system_profile_code = apm.system_profile_code
3032: AND ppp.payment_format_code = 'IBY_PAY_ECE'
3033: AND apm.applicable_type_code = 'PAYMENT_METHOD'