APPS.JAI_RCV_TRX_PROCESSING_PKG dependencies on JAI_RCV_RTV_BATCH_GRPS

Line 2092: INSERT INTO jai_rcv_rtv_batch_grps(

2088:
2089: ln_user_id := fnd_global.user_id;
2090: ln_login_id := fnd_global.user_id;
2091:
2092: INSERT INTO jai_rcv_rtv_batch_grps(
2093: batch_group_id,
2094: batch_num, regime_code, organization_id, location_id,
2095: vendor_id, vendor_site_id, invoice_no, invoice_date,
2096: creation_date, created_by, last_update_date, last_updated_by, last_update_login

Line 2098: jai_rcv_rtv_batch_grps_s.nextval,

2094: batch_num, regime_code, organization_id, location_id,
2095: vendor_id, vendor_site_id, invoice_no, invoice_date,
2096: creation_date, created_by, last_update_date, last_updated_by, last_update_login
2097: ) VALUES (
2098: jai_rcv_rtv_batch_grps_s.nextval,
2099: pn_batch_num, pv_regime_code, pn_organization_id, pn_location_id,
2100: pn_vendor_id, pn_vendor_site_id, pv_invoice_no, pd_invoice_date,
2101: sysdate, ln_user_id, sysdate, ln_user_id, ln_login_id
2102: ) RETURNING batch_group_id INTO pn_batch_group_id;

Line 2188: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;

2184:
2185: lv_excise_inv_gen_action VARCHAR2(50);
2186: lv_vat_inv_gen_action VARCHAR2(50);
2187:
2188: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2189: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2190:
2191: begin
2192:

Line 2189: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;

2185: lv_excise_inv_gen_action VARCHAR2(50);
2186: lv_vat_inv_gen_action VARCHAR2(50);
2187:
2188: ln_excise_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2189: ln_vat_batch_group_id jai_rcv_rtv_batch_grps.batch_group_id%TYPE;
2190:
2191: begin
2192:
2193: lv_statement_id := '0';