APPS.IBY_UPG_PPP_PKG dependencies on IBY_UPG_PPP_B

Line 97: cursor C is select ROWID from IBY_UPG_PPP_B

93: X_LOGICAL_GROUPING_MODE in VARCHAR2,
94: X_BATCH_BOOKING_FLAG in VARCHAR2,
95: X_INST_GROUP_BY_PAYMENT_METHOD in VARCHAR2
96: ) is
97: cursor C is select ROWID from IBY_UPG_PPP_B
98: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
99: ;
100: begin
101: insert into IBY_UPG_PPP_B (

Line 101: insert into IBY_UPG_PPP_B (

97: cursor C is select ROWID from IBY_UPG_PPP_B
98: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
99: ;
100: begin
101: insert into IBY_UPG_PPP_B (
102: REMIT_PMT_DETAILS_LENGTH_LIM,
103: REMIT_REMITTANCE_ADVICE_FORMAT,
104: REMIT_SRA_OVERRIDE_PAYEE_FLAG,
105: REMIT_ADVICE_DELIVERY_METHOD,

Line 493: from IBY_UPG_PPP_B

489: ELECTRONIC_PROCESSING_CHANNEL,
490: LOGICAL_GROUPING_MODE,
491: BATCH_BOOKING_FLAG,
492: INST_GROUP_BY_PAYMENT_METHOD
493: from IBY_UPG_PPP_B
494: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE
495: for update of SYSTEM_PROFILE_CODE nowait;
496: recinfo c%rowtype;
497:

Line 879: iby_upg_ppp_b ppp,

875: sfa.org_id
876: FROM jg_zz_sys_formats_all_b sfa)
877: sfgdf,
878: iby_formats_b ipf,
879: iby_upg_ppp_b ppp,
880: iby_bepinfo bep,
881: iby_bepkeys KEY
882: WHERE cf.format_payments_program_id =
883: pp.program_id

Line 909: iby_upg_ppp_b ppb,

905:
906: SELECT distinct(ppb.system_profile_code) system_profile_code
907: FROM iby_formats_b ipf,
908: iby_upg_ppp_tl ppp,
909: iby_upg_ppp_b ppb,
910: iby_acct_pmt_profiles_b app,
911: iby_bepinfo bep,
912: iby_bepkeys key1
913: WHERE(ipf.reference_format_code IS NULL OR(ipf.reference_format_code IS NOT NULL

Line 957: update IBY_UPG_PPP_B set

953: FETCH get_sys_prof_code BULK COLLECT INTO l_sys_profile_code_tab;
954: CLOSE get_sys_prof_code;
955:
956:
957: update IBY_UPG_PPP_B set
958: REMIT_PMT_DETAILS_LENGTH_LIM = X_REMIT_PMT_DETAILS_LENGTH_LIM,
959: REMIT_REMITTANCE_ADVICE_FORMAT = X_REMIT_REMITTANCE_ADVICE_FORM,
960: REMIT_SRA_OVERRIDE_PAYEE_FLAG = X_REMIT_SRA_OVERRIDE_PAYEE_FLA,
961: REMIT_ADVICE_DELIVERY_METHOD = X_REMIT_ADVICE_DELIVERY_METHOD,

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

1047: raise no_data_found;
1048: end if;
1049:
1050: -- Uncomment the below code for debugging..
1051: -- kp_msg('The updation of iby_upg_ppp_b tables has been done successfully');
1052: -- CODE TO UPDATE BASE TABLES
1053:
1054: FOR i IN l_sys_profile_code_tab.FIRST .. l_sys_profile_code_tab.LAST LOOP
1055:

Line 1218: delete from IBY_UPG_PPP_B

1214: if (sql%notfound) then
1215: raise no_data_found;
1216: end if;
1217:
1218: delete from IBY_UPG_PPP_B
1219: where SYSTEM_PROFILE_CODE = X_SYSTEM_PROFILE_CODE;
1220:
1221: if (sql%notfound) then
1222: raise no_data_found;

Line 1232: from IBY_UPG_PPP_B B

1228: begin
1229: delete from IBY_UPG_PPP_TL T
1230: where not exists
1231: (select NULL
1232: from IBY_UPG_PPP_B B
1233: where B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
1234: );
1235:
1236: update IBY_UPG_PPP_TL T set (