APPS.INL_CHARGE_PVT dependencies on INL_SHIP_HEADERS

Line 1643: p_ship_header_rec IN inl_ship_headers%ROWTYPE,

1639: -- Version : Current version 1.0
1640: --
1641: -- Notes :
1642: PROCEDURE Prepare_AndGetChargesFromQP(
1643: p_ship_header_rec IN inl_ship_headers%ROWTYPE,
1644: p_ship_ln_group_tbl IN ship_ln_group_tbl_tp,
1645: p_ship_ln_tbl IN ship_ln_tbl_tp,
1646: x_charge_ln_tbl IN OUT NOCOPY charge_ln_tbl, -- Bug #10100951
1647: x_return_status OUT NOCOPY VARCHAR2

Line 2139: inl_ship_headers_all sh,

2135: BEGIN
2136: SELECT sl.ship_line_id
2137: INTO l_simul_ship_line_id
2138: FROM inl_simulations s,
2139: inl_ship_headers_all sh,
2140: inl_ship_lines_all sl
2141: WHERE -- s.parent_table_name = DECODE(sh.interface_source_code,'PO','PO_HEADERS','-1')
2142: sh.interface_source_code = DECODE(s.parent_table_name,'PO_HEADERS','PO',
2143: DECODE(s.parent_table_name, 'PO_RELEASES', 'PO', '-1')) -- Bug 14280113

Line 2512: l_ship_header_rec inl_ship_headers%ROWTYPE;

2508: -- ship ln
2509: l_ship_ln_tbl ship_ln_tbl_tp;
2510:
2511: -- header
2512: l_ship_header_rec inl_ship_headers%ROWTYPE;
2513: l_allocation_basis_uom_class VARCHAR2(30);
2514: l_alloc_bas_uom_class_err_flag VARCHAR2(1):='N';
2515:
2516: BEGIN

Line 2662: FROM inl_ship_headers sh

2658:
2659: --prepare hook information
2660: SELECT *
2661: INTO l_ship_header_rec
2662: FROM inl_ship_headers sh
2663: WHERE sh.ship_header_id = p_ship_header_id;
2664:
2665: SELECT *
2666: BULK COLLECT INTO l_ship_ln_group_tbl

Line 2754: inl_ship_headers_all sh,

2750:
2751: SELECT COUNT(*)
2752: INTO l_firm_simulation
2753: FROM inl_simulations s,
2754: inl_ship_headers_all sh,
2755: inl_ship_lines_all sl2, -- Simulated Shipment Line
2756: inl_ship_lines_all sl1 -- ELC Shipment Line
2757: WHERE s.simulation_id = sh.simulation_id
2758: AND s.firmed_flag = 'Y'