DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_MANUAL_TRXS

Line 615: cursor c_get_man_trx_rec (cp_trx_number jai_rgm_manual_trxs.transaction_number%type)

611:
612: r_src_rec c_get_src_rec%rowtype;
613: r_dest_rec c_get_dest_rec%rowtype;
614:
615: cursor c_get_man_trx_rec (cp_trx_number jai_rgm_manual_trxs.transaction_number%type)
616: is
617: select party_type
618: , party_id
619: , transaction_date

Line 622: from JAI_RGM_MANUAL_TRXS

618: , party_id
619: , transaction_date
620: , remarks
621: , invoice_number
622: from JAI_RGM_MANUAL_TRXS
623: where transaction_number = cp_trx_number;
624:
625: r_man_trx_rec c_get_man_trx_rec%rowtype;
626:

Line 3208: update jai_rgm_manual_trxs

3204: and customer_trx_line_id = rec.document_line_id;
3205:
3206: elsif rec.transaction_source = 'MANUAL' then
3207:
3208: update jai_rgm_manual_trxs
3209: set service_type_code = rec.service_type_code
3210: , last_update_date = sysdate
3211: , last_updated_by = lv_user_id
3212: where transaction_number = rec.document_id;