APPS.JAI_RCV_RND_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 126: FROM rcv_shipment_headers

122: CURSOR get_dbname IS SELECT name FROM v$database;
123:
124: CURSOR c_vendor(p_shipment_header_id IN NUMBER) IS
125: SELECT vendor_id, vendor_site_id, receipt_num
126: FROM rcv_shipment_headers
127: WHERE shipment_header_id = p_shipment_header_id;
128:
129: v_slno NUMBER;
130: v_balance NUMBER;

Line 267: v_receipt_num rcv_shipment_headers.receipt_num%type;

263: v_proceed_for_2nd_claim VARCHAR(1) ; --File.Sql.35 Cbabu := 'N';
264:
265: v_exc_inv_rnd_counter NUMBER; --File.Sql.35 Cbabu := 0;
266: v_rnd_entries_to_be_passed NUMBER;--File.Sql.35 Cbabu := 0;
267: v_receipt_num rcv_shipment_headers.receipt_num%type;
268: v_transaction_type rcv_transactions.transaction_type%type;
269:
270: lv_ttype_correct rcv_transactions.transaction_type%type ;
271: BEGIN

Line 376: The vendor_id and vendor_site_id for rounding_entries are populated from rcv_shipment_headers

372: excise_invoice_date. But these two can be same for different vendors. So added a check to include vendor_id
373: and vendor_site_id wherever applicable. The cursor to fetch parent register id is also modified to include
374: shipment header id.
375:
376: The vendor_id and vendor_site_id for rounding_entries are populated from rcv_shipment_headers
377: This is now changed to be populated from the parent entry in ja_in_rg23_part_ii.
378:
379: These changes were made in bug#5478107 at PRE Addl. CVD enh level. The same are
380: forward ported to the latest code line.

Line 1840: --v_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;

1836: p_receipt_num varchar2
1837: ) IS
1838:
1839: v_organization_code ORG_ORGANIZATION_DEFINITIONS.organization_code%TYPE;
1840: --v_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;
1841: v_period_name GL_PERIODS.period_name%TYPE;
1842:
1843: v_transaction_type VARCHAR2(20);
1844: --v_shipment_header_id NUMBER;

Line 1853: FROM rcv_shipment_headers

1849: WHERE rounding_id = cp_rounding_id;
1850:
1851: CURSOR c_receipt_num(cp_shipment_header_id IN NUMBER) IS
1852: SELECt receipt_num
1853: FROM rcv_shipment_headers
1854: WHERE shipment_header_id = cp_shipment_header_id;
1855:
1856: /* Bug 5243532. Added by Lakshmi Gopalsami
1857: * Removed org_organization_definitions from the

Line 2017: FROM rcv_shipment_headers

2013: v_tot_lines_cnt NUMBER ;--File.Sql.35 Cbabu := 0;
2014:
2015: CURSOR c_vendor(p_shipment_header_id IN NUMBER) IS
2016: SELECT vendor_id, vendor_site_id, receipt_num
2017: FROM rcv_shipment_headers
2018: WHERE shipment_header_id = p_shipment_header_id;
2019:
2020: v_slno NUMBER;
2021: v_balance NUMBER;

Line 2115: v_receipt_num rcv_shipment_headers.receipt_num%TYPE;

2111: v_exc_inv_rnd_counter NUMBER ;--File.Sql.35 Cbabu := 0;
2112:
2113: lv_process_status VARCHAR2(3);
2114: lv_process_message VARCHAR2(1996);
2115: v_receipt_num rcv_shipment_headers.receipt_num%TYPE;
2116: v_pla_register_id NUMBER;
2117:
2118: lv_ttype_correct JAI_RCV_TRANSACTIONS.transaction_type%type ;
2119: