DBA Data[Home] [Help]

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 1839: --v_receipt_num RCV_SHIPMENT_HEADERS.receipt_num%TYPE;

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

Line 1852: FROM rcv_shipment_headers

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

Line 2016: FROM rcv_shipment_headers

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

Line 2114: v_receipt_num rcv_shipment_headers.receipt_num%TYPE;

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