APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_RTV_BATCH_GRPS

Line 2500: INSERT INTO jai_rcv_rtv_batch_grps(

2496:
2497: ln_user_id := fnd_global.user_id;
2498: ln_login_id := fnd_global.user_id;
2499:
2500: INSERT INTO jai_rcv_rtv_batch_grps(
2501: batch_group_id,
2502: batch_num, regime_code, organization_id, location_id,
2503: vendor_id, vendor_site_id, invoice_no, invoice_date,
2504: creation_date, created_by, last_update_date, last_updated_by, last_update_login

Line 2506: jai_rcv_rtv_batch_grps_s.nextval,

2502: batch_num, regime_code, organization_id, location_id,
2503: vendor_id, vendor_site_id, invoice_no, invoice_date,
2504: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2505: ) VALUES (
2506: jai_rcv_rtv_batch_grps_s.nextval,
2507: pn_batch_num, pv_regime_code, pn_organization_id, pn_location_id,
2508: pn_vendor_id, pn_vendor_site_id, pv_invoice_no, pd_invoice_date,
2509: sysdate, ln_user_id, sysdate, ln_user_id, ln_login_id
2510: ) RETURNING batch_group_id INTO pn_batch_group_id;

Line 2597: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;

2593:
2594: lv_excise_inv_gen_action VARCHAR2(50);
2595: lv_vat_inv_gen_action VARCHAR2(50);
2596:
2597: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2598: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2599:
2600: begin
2601:

Line 2598: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;

2594: lv_excise_inv_gen_action VARCHAR2(50);
2595: lv_vat_inv_gen_action VARCHAR2(50);
2596:
2597: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2598: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2599:
2600: begin
2601:
2602: lv_statement_id := '0';