eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_LANDEDCOST_PVT dependencies on INL_ALLOCATIONS

Line 1635: -- taxes should also generate lines in INL_ALLOCATIONS.

1631: -- Type : Private
1632: -- Function :
1633: --
1634: -- Amounts from Landed Cost Shipment Lines as well as amounts from charges and
1635: -- taxes should also generate lines in INL_ALLOCATIONS.
1636: --
1637: -- Landed Cost Shipment Lines that belong to components that are associated to others
1638: -- should generate allocations with LANDED_COST_FLAG = N.
1639: --

Line 1942: l_debug_info := 'Inserting into inl_allocations';

1938: p_procedure_name => l_program_name,
1939: p_var_name => l_debug_info,
1940: p_var_value => TO_CHAR(l_factor));
1941:
1942: l_debug_info := 'Inserting into inl_allocations';
1943: INL_LOGGING_PVT.Log_Statement (
1944: p_module_name => g_module_name,
1945: p_procedure_name => l_program_name,
1946: p_debug_info => l_debug_info);

Line 1985: l_debug_info := 'Inserting into inl_allocations';

1981: END LOOP;
1982: END IF;
1983: END IF;
1984: IF l_count = 0 THEN
1985: l_debug_info := 'Inserting into inl_allocations';
1986: INL_LOGGING_PVT.Log_Statement (
1987: p_module_name => g_module_name,
1988: p_procedure_name => l_program_name,
1989: p_debug_info => l_debug_info);

Line 2001: INSERT INTO inl_allocations

1997: p_procedure_name => l_program_name,
1998: p_var_name => 'p_amount',
1999: p_var_value => p_amount);
2000:
2001: INSERT INTO inl_allocations
2002: (allocation_id, /* 01 */
2003: ship_header_id, /* 02 */
2004: association_id, /* 03 */
2005: ship_line_id, /* 04 */

Line 2019: (inl_allocations_s.NEXTVAL, /* 01 */

2015: last_updated_by, /* 14 */
2016: last_update_date, /* 15 */
2017: last_update_login) /* 16 */
2018: VALUES
2019: (inl_allocations_s.NEXTVAL, /* 01 */
2020: p_ship_header_id, /* 02 */
2021: p_association_id, /* 03 */
2022: p_ship_line_id, /* 04 */
2023: l_from_component_name, /* 05 */

Line 2870: FROM inl_allocations

2866: ship_header_id,
2867: association_id,
2868: ship_line_id,
2869: adjustment_num
2870: FROM inl_allocations
2871: --- SCM-051
2872: ---
2873: WHERE ABS(adjustment_num) = ABS(p_adjustment_num)
2874: --- SCM-051

Line 2919: l_debug_info := 'Updating inl_allocations with parent_allocation_id';

2915: THEN
2916: FOR iupdalloc IN 1 .. updalloc_List.COUNT --Bulk implem
2917: LOOP
2918:
2919: l_debug_info := 'Updating inl_allocations with parent_allocation_id';
2920: INL_LOGGING_PVT.Log_Statement (
2921: p_module_name => g_module_name,
2922: p_procedure_name => l_program_name,
2923: p_debug_info => l_debug_info);

Line 2925: UPDATE inl_allocations a1

2921: p_module_name => g_module_name,
2922: p_procedure_name => l_program_name,
2923: p_debug_info => l_debug_info);
2924:
2925: UPDATE inl_allocations a1
2926: SET a1.parent_allocation_id = (SELECT MIN(a2.allocation_id)
2927: FROM inl_allocations a2
2928: WHERE a2.ship_header_id = updalloc_List(iUpdAlloc).ship_header_id
2929: AND NVL(a2.association_id,0) = NVL(updalloc_List(iUpdAlloc).association_id,0)

Line 2927: FROM inl_allocations a2

2923: p_debug_info => l_debug_info);
2924:
2925: UPDATE inl_allocations a1
2926: SET a1.parent_allocation_id = (SELECT MIN(a2.allocation_id)
2927: FROM inl_allocations a2
2928: WHERE a2.ship_header_id = updalloc_List(iUpdAlloc).ship_header_id
2929: AND NVL(a2.association_id,0) = NVL(updalloc_List(iUpdAlloc).association_id,0)
2930: AND (a2.ship_line_id = updalloc_List(iUpdAlloc).ship_line_id
2931: OR a2.ship_line_id = (SELECT a.parent_ship_line_id

Line 2936: AND NOT EXISTS (SELECT 'X' FROM inl_allocations a1

2932: FROM inl_ship_lines_all a
2933: WHERE a.ship_line_id = updalloc_List(iUpdAlloc).ship_line_id))
2934:
2935: AND a2.adjustment_num = 0
2936: AND NOT EXISTS (SELECT 'X' FROM inl_allocations a1
2937: ------ bug #7674125
2938: WHERE NVL(a1.parent_allocation_id,0) = NVL(a2.allocation_id,0)
2939: AND a1.ship_header_id = a2.ship_header_id
2940: AND NVL(a1.association_id,0) = NVL(a2.association_id,0)

Line 3386: FROM inl_allocations

3382: --- SCM-051
3383: SELECT MAX(ABS(adjustment_num))
3384: --- SCM-051
3385: INTO l_first_adjustment_num
3386: FROM inl_allocations
3387: WHERE ship_header_id = p_ship_header_id;
3388:
3389: INL_LOGGING_PVT.Log_Variable (
3390: p_module_name => g_module_name,

Line 3611: DELETE FROM INL_allocations

3607: p_module_name => g_module_name,
3608: p_procedure_name => l_program_name,
3609: p_debug_info => l_debug_info);
3610:
3611: DELETE FROM INL_allocations
3612: WHERE ship_header_id = p_ship_header_id
3613: AND ABS(adjustment_num) = ABS(l_current_adjustment_num);
3614: --SCM-051
3615: l_debug_info:=l_debug_info||' => '||sql%ROWCOUNT;

Line 3915: inl_allocations al

3911: INTO l_inclusive_tax_amt
3912: FROM
3913: inl_tax_lines t, --BUG#8330505
3914: inl_associations assoc,
3915: inl_allocations al
3916: WHERE t.tax_amt_included_flag = 'Y'
3917: AND t.tax_line_id = (SELECT MAX(tl.tax_line_id)
3918: FROM inl_tax_lines tl
3919: --- SCM-051