APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_DIS_SRC_HDRS

Line 170: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type

166: and recs.settlement_id is not null
167: and recs.service_type_code is not null
168: and rownum = 1;
169:
170: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
171: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
172: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
173: )
174: is

Line 171: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type

167: and recs.service_type_code is not null
168: and rownum = 1;
169:
170: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
171: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
172: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
173: )
174: is
175: select transfer_number

Line 172: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type

168: and rownum = 1;
169:
170: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
171: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
172: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
173: )
174: is
175: select transfer_number
176: ,transaction_date

Line 179: from jai_rgm_dis_src_hdrs

175: select transfer_number
176: ,transaction_date
177: ,party_id
178: ,location_id
179: from jai_rgm_dis_src_hdrs
180: where party_type = cp_party_type
181: and party_id = cp_party_id
182: and transfer_id = cp_transfer_id;
183:

Line 1793: update jai_rgm_dis_src_hdrs

1789:
1790: elsif rec.transaction_source in ('SERVICE_DISTRIBUTE_OUT') then
1791:
1792: -- Update Source of the distribution
1793: update jai_rgm_dis_src_hdrs
1794: set service_type_code = rec.service_type_code
1795: , last_update_date = sysdate
1796: , last_updated_by = lv_user_id
1797: , last_update_login = lv_login_id