DBA Data[Home] [Help]

APPS.FTE_TL_COST_ALLOCATION dependencies on FTE_FREIGHT_COSTS_TEMP

Line 158: --Structures used to store outputs for bulk inserts into FTE_FREIGHT_COSTS_TEMP

154:
155: --Index for arrays
156: G_B_index NUMBER;
157:
158: --Structures used to store outputs for bulk inserts into FTE_FREIGHT_COSTS_TEMP
159:
160: TYPE T_FREIGHT_COST_ID_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
161: TYPE T_FREIGHT_COST_TYPE_ID_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
162: TYPE T_UNIT_AMOUNT_typ IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 635: SELECT fte_freight_costs_temp_s.nextval

631:
632:
633: CURSOR C_Next_Freight_Cost_Id
634: IS
635: SELECT fte_freight_costs_temp_s.nextval
636: FROM sys.dual;
637:
638: l_return_status VARCHAR2(1);
639:

Line 763: INSERT INTO FTE_FREIGHT_COSTS_TEMP (

759: IF (G_B_T_FREIGHT_COST_ID.first IS NOT NULL)
760: THEN
761:
762: FORALL i IN G_B_T_FREIGHT_COST_ID.first .. G_B_T_FREIGHT_COST_ID.last
763: INSERT INTO FTE_FREIGHT_COSTS_TEMP (
764: freight_cost_id,
765: freight_cost_type_id,
766: unit_amount,
767: calculation_method,