DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_RGM_MANUAL_TRXS

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

197:
198: r_src_rec c_get_src_rec%rowtype;
199: r_dest_rec c_get_dest_rec%rowtype;
200:
201: cursor c_get_man_trx_rec (cp_trx_number jai_rgm_manual_trxs.transaction_number%type)
202: is
203: select party_type
204: , party_id
205: , transaction_date

Line 208: from JAI_RGM_MANUAL_TRXS

204: , party_id
205: , transaction_date
206: , remarks
207: , invoice_number
208: from JAI_RGM_MANUAL_TRXS
209: where transaction_number = cp_trx_number;
210:
211: r_man_trx_rec c_get_man_trx_rec%rowtype;
212:

Line 1784: update jai_rgm_manual_trxs

1780: and customer_trx_line_id = rec.document_line_id;
1781:
1782: elsif rec.transaction_source = 'MANUAL' then
1783:
1784: update jai_rgm_manual_trxs
1785: set service_type_code = rec.service_type_code
1786: , last_update_date = sysdate
1787: , last_updated_by = lv_user_id
1788: where transaction_number = rec.document_id;