APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_DIS_SRC_HDRS

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

580: and recs.settlement_id is not null
581: and recs.service_type_code is not null
582: and rownum = 1;
583:
584: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
585: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
586: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
587: )
588: is

Line 585: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type

581: and recs.service_type_code is not null
582: and rownum = 1;
583:
584: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
585: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
586: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
587: )
588: is
589: select transfer_number

Line 586: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type

582: and rownum = 1;
583:
584: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type
585: , cp_party_type jai_rgm_dis_src_hdrs.party_type%type
586: , cp_party_id jai_rgm_dis_src_hdrs.party_id%type
587: )
588: is
589: select transfer_number
590: ,transaction_date

Line 593: from jai_rgm_dis_src_hdrs

589: select transfer_number
590: ,transaction_date
591: ,party_id
592: ,location_id
593: from jai_rgm_dis_src_hdrs
594: where party_type = cp_party_type
595: and party_id = cp_party_id
596: and transfer_id = cp_transfer_id;
597:

Line 3218: update jai_rgm_dis_src_hdrs

3214: --added service_distribute-in for bug#13375399
3215: elsif rec.transaction_source in ('SERVICE_DISTRIBUTE_OUT','SERVICE_DISTRIBUTE_IN') then
3216:
3217: -- Update Source of the distribution
3218: update jai_rgm_dis_src_hdrs
3219: set service_type_code = rec.service_type_code
3220: , last_update_date = sysdate
3221: , last_updated_by = lv_user_id
3222: , last_update_login = lv_login_id