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.FTE_FREIGHT_PRICING dependencies on DBMS_UTILITY

Line 316: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id

312: END IF;
313: END Get_Basis_Meaning;
314:
315: PROCEDURE MDC_Get_child_fraction(
316: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
317: x_fraction OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
318: x_return_status OUT NOCOPY VARCHAR2) IS
319:
320: i NUMBER;

Line 317: x_fraction OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,

313: END Get_Basis_Meaning;
314:
315: PROCEDURE MDC_Get_child_fraction(
316: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
317: x_fraction OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
318: x_return_status OUT NOCOPY VARCHAR2) IS
319:
320: i NUMBER;
321: l_uom VARCHAR2(30);

Line 324: l_detail_weight DBMS_UTILITY.NUMBER_ARRAY;

320: i NUMBER;
321: l_uom VARCHAR2(30);
322: l_weight NUMBER;
323: l_parent_detail_id NUMBER;
324: l_detail_weight DBMS_UTILITY.NUMBER_ARRAY;
325: l_total_lpn_weight DBMS_UTILITY.NUMBER_ARRAY;
326:
327: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
328:

Line 325: l_total_lpn_weight DBMS_UTILITY.NUMBER_ARRAY;

321: l_uom VARCHAR2(30);
322: l_weight NUMBER;
323: l_parent_detail_id NUMBER;
324: l_detail_weight DBMS_UTILITY.NUMBER_ARRAY;
325: l_total_lpn_weight DBMS_UTILITY.NUMBER_ARRAY;
326:
327: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;
328:
329: BEGIN

Line 420: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,

416:
417: END MDC_Get_child_fraction;
418:
419: PROCEDURE MDC_Get_LPN_Cost_rec(
420: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,
421: p_freight_cost_main_tab IN Freight_Cost_Main_Tab_Type,
422: p_freight_cost_temp_tab IN Freight_Cost_Temp_Tab_Type,
423: x_ref OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
424: x_return_status OUT NOCOPY VARCHAR2) IS

Line 423: x_ref OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,

419: PROCEDURE MDC_Get_LPN_Cost_rec(
420: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,
421: p_freight_cost_main_tab IN Freight_Cost_Main_Tab_Type,
422: p_freight_cost_temp_tab IN Freight_Cost_Temp_Tab_Type,
423: x_ref OUT NOCOPY DBMS_UTILITY.NUMBER_ARRAY,
424: x_return_status OUT NOCOPY VARCHAR2) IS
425:
426: i NUMBER;
427: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 477: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id

473: END MDC_Get_LPN_Cost_rec;
474:
475: PROCEDURE MDC_Alloc_From_consol_LPN(
476: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
477: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
478: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
479: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_Main_Tab_Type,
480: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
481: x_freight_cost_main_charge IN OUT NOCOPY Freight_Cost_Main_Tab_Type,

Line 478: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id

474:
475: PROCEDURE MDC_Alloc_From_consol_LPN(
476: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
477: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
478: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
479: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_Main_Tab_Type,
480: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
481: x_freight_cost_main_charge IN OUT NOCOPY Freight_Cost_Main_Tab_Type,
482: x_freight_cost_temp_charge IN OUT NOCOPY Freight_Cost_temp_Tab_Type,

Line 488: l_price_ref DBMS_UTILITY.NUMBER_ARRAY;

484: i NUMBER;
485: j NUMBER;
486: n NUMBER;
487: l_temp NUMBER;
488: l_price_ref DBMS_UTILITY.NUMBER_ARRAY;
489:
490:
491: l_fractions DBMS_UTILITY.NUMBER_ARRAY;
492: l_dtl_fraction NUMBER;

Line 491: l_fractions DBMS_UTILITY.NUMBER_ARRAY;

487: l_temp NUMBER;
488: l_price_ref DBMS_UTILITY.NUMBER_ARRAY;
489:
490:
491: l_fractions DBMS_UTILITY.NUMBER_ARRAY;
492: l_dtl_fraction NUMBER;
493: l_LPN_rec_index NUMBER;
494:
495: l_child_dtl_temp_rec Freight_Cost_temp_Rec_Type;

Line 809: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id

805:
806:
807: PROCEDURE Create_Parent_Dleg_Summaries(
808: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
809: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
810: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
811: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
812: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
813: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,

Line 810: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id

806:
807: PROCEDURE Create_Parent_Dleg_Summaries(
808: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
809: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
810: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
811: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
812: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
813: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
814: x_return_status OUT NOCOPY VARCHAR2) IS

Line 811: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,

807: PROCEDURE Create_Parent_Dleg_Summaries(
808: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
809: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
810: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
811: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
812: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
813: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
814: x_return_status OUT NOCOPY VARCHAR2) IS
815: i NUMBER;

Line 816: l_parent_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;

812: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
813: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
814: x_return_status OUT NOCOPY VARCHAR2) IS
815: i NUMBER;
816: l_parent_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
817: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
818: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
819: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
820: l_return_status VARCHAR2(1);

Line 817: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;

813: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
814: x_return_status OUT NOCOPY VARCHAR2) IS
815: i NUMBER;
816: l_parent_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
817: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
818: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
819: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
820: l_return_status VARCHAR2(1);
821: l_index NUMBER;

Line 980: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,

976:
977:
978: PROCEDURE Create_Child_Dleg_Summaries(
979: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
980: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
981: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
982: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
983: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
984: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_main_Tab_Type,

Line 981: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id

977:
978: PROCEDURE Create_Child_Dleg_Summaries(
979: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
980: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
981: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
982: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
983: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
984: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_main_Tab_Type,
985: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,

Line 982: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id

978: PROCEDURE Create_Child_Dleg_Summaries(
979: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
980: p_dleg_to_delivery IN DBMS_UTILITY.NUMBER_ARRAY,
981: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
982: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
983: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_main_Tab_Type,
984: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_main_Tab_Type,
985: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
986: x_return_status OUT NOCOPY VARCHAR2) IS

Line 988: l_child_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;

984: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_main_Tab_Type,
985: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
986: x_return_status OUT NOCOPY VARCHAR2) IS
987:
988: l_child_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
989: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
990: i NUMBER;
991: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
992: l_freight_cost_temp_price Freight_Cost_Temp_Rec_Type;

Line 989: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;

985: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
986: x_return_status OUT NOCOPY VARCHAR2) IS
987:
988: l_child_dleg_summaries DBMS_UTILITY.NUMBER_ARRAY;
989: l_existing_dlegs DBMS_UTILITY.NUMBER_ARRAY;
990: i NUMBER;
991: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
992: l_freight_cost_temp_price Freight_Cost_Temp_Rec_Type;
993: l_freight_cost_type_id NUMBER;

Line 1185: p_delivery_to_dleg IN DBMS_UTILITY.NUMBER_ARRAY,

1181: END Create_Child_Dleg_Summaries;
1182:
1183:
1184: PROCEDURE Populate_Dleg_Id(
1185: p_delivery_to_dleg IN DBMS_UTILITY.NUMBER_ARRAY,
1186: x_freight_cost_temp IN OUT NOCOPY Freight_Cost_Temp_Tab_Type,
1187: x_return_status OUT NOCOPY VARCHAR2 ) IS
1188:
1189: i NUMBER;

Line 1227: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id

1223: END Populate_Dleg_Id;
1224:
1225: PROCEDURE Create_LPN_Summary(
1226: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
1227: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
1228: x_freight_cost_main_price IN OUT NOCOPY Freight_Cost_Main_Tab_Type,
1229: x_freight_cost_temp_price IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
1230: x_freight_cost_main_charge IN OUT NOCOPY Freight_Cost_Main_Tab_Type,
1231: x_freight_cost_temp_charge IN OUT NOCOPY Freight_Cost_temp_Tab_Type,

Line 1235: l_LPN_summaries DBMS_UTILITY.NUMBER_ARRAY;

1231: x_freight_cost_temp_charge IN OUT NOCOPY Freight_Cost_temp_Tab_Type,
1232: x_return_status OUT NOCOPY VARCHAR2) IS
1233:
1234: i NUMBER;
1235: l_LPN_summaries DBMS_UTILITY.NUMBER_ARRAY;
1236: l_existing_LPN DBMS_UTILITY.NUMBER_ARRAY;--If it is required to update existing LPN summaries
1237: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1238: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
1239: l_freight_cost_type_id NUMBER;

Line 1236: l_existing_LPN DBMS_UTILITY.NUMBER_ARRAY;--If it is required to update existing LPN summaries

1232: x_return_status OUT NOCOPY VARCHAR2) IS
1233:
1234: i NUMBER;
1235: l_LPN_summaries DBMS_UTILITY.NUMBER_ARRAY;
1236: l_existing_LPN DBMS_UTILITY.NUMBER_ARRAY;--If it is required to update existing LPN summaries
1237: l_freight_cost_main_price WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
1238: l_freight_cost_temp_price Freight_Cost_temp_Rec_Type;
1239: l_freight_cost_type_id NUMBER;
1240: l_return_status VARCHAR2(1);

Line 1388: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id

1384: END Create_LPN_Summary;
1385:
1386: PROCEDURE MDC_Check_Rated(
1387: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
1388: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
1389: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
1390: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
1391: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
1392: p_freight_cost_main_price IN Freight_Cost_Main_Tab_Type,

Line 1389: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id

1385:
1386: PROCEDURE MDC_Check_Rated(
1387: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
1388: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
1389: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
1390: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
1391: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
1392: p_freight_cost_main_price IN Freight_Cost_Main_Tab_Type,
1393: p_freight_cost_temp_price IN Freight_Cost_Temp_Tab_Type,

Line 1390: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id

1386: PROCEDURE MDC_Check_Rated(
1387: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
1388: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
1389: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
1390: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
1391: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
1392: p_freight_cost_main_price IN Freight_Cost_Main_Tab_Type,
1393: p_freight_cost_temp_price IN Freight_Cost_Temp_Tab_Type,
1394: p_fc_main_update_rows IN Freight_Cost_Main_Tab_Type, -- For update of SUMMARY records

Line 1391: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id

1387: p_save_flag IN VARCHAR2, -- Whether to save to TEMP table or temp table
1388: p_consol_LPNs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by consol LPN detail id
1389: p_consol_LPN_children IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child detail id, value of parent consol detail id
1390: p_parent_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by parent dleg id
1391: p_child_dlegs IN DBMS_UTILITY.NUMBER_ARRAY,--Indexed by child dleg id, value of parent dleg id
1392: p_freight_cost_main_price IN Freight_Cost_Main_Tab_Type,
1393: p_freight_cost_temp_price IN Freight_Cost_Temp_Tab_Type,
1394: p_fc_main_update_rows IN Freight_Cost_Main_Tab_Type, -- For update of SUMMARY records
1395: x_child_details_rated OUT NOCOPY VARCHAR2,

Line 1402: l_child_detail_rated DBMS_UTILITY.NUMBER_ARRAY;

1398: x_parent_dlegs_rated OUT NOCOPY VARCHAR2,
1399: x_return_status OUT NOCOPY VARCHAR2) IS
1400:
1401:
1402: l_child_detail_rated DBMS_UTILITY.NUMBER_ARRAY;
1403: l_consol_LPN_rated DBMS_UTILITY.NUMBER_ARRAY;
1404: l_child_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1405: l_parent_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1406: i NUMBER;

Line 1403: l_consol_LPN_rated DBMS_UTILITY.NUMBER_ARRAY;

1399: x_return_status OUT NOCOPY VARCHAR2) IS
1400:
1401:
1402: l_child_detail_rated DBMS_UTILITY.NUMBER_ARRAY;
1403: l_consol_LPN_rated DBMS_UTILITY.NUMBER_ARRAY;
1404: l_child_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1405: l_parent_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1406: i NUMBER;
1407: l_return_status VARCHAR2(1);

Line 1404: l_child_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;

1400:
1401:
1402: l_child_detail_rated DBMS_UTILITY.NUMBER_ARRAY;
1403: l_consol_LPN_rated DBMS_UTILITY.NUMBER_ARRAY;
1404: l_child_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1405: l_parent_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1406: i NUMBER;
1407: l_return_status VARCHAR2(1);
1408:

Line 1405: l_parent_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;

1401:
1402: l_child_detail_rated DBMS_UTILITY.NUMBER_ARRAY;
1403: l_consol_LPN_rated DBMS_UTILITY.NUMBER_ARRAY;
1404: l_child_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1405: l_parent_dlegs_rated DBMS_UTILITY.NUMBER_ARRAY;
1406: i NUMBER;
1407: l_return_status VARCHAR2(1);
1408:
1409: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_DBG;

Line 1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;

1571: x_freight_cost_temp_charge IN OUT NOCOPY Freight_Cost_Temp_Tab_Type,
1572: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_Main_Tab_Type, -- For update of SUMMARY records
1573: x_return_status OUT NOCOPY VARCHAR2 ) IS
1574:
1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id

Line 1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;

1572: x_fc_main_update_rows IN OUT NOCOPY Freight_Cost_Main_Tab_Type, -- For update of SUMMARY records
1573: x_return_status OUT NOCOPY VARCHAR2 ) IS
1574:
1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;

Line 1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;

1573: x_return_status OUT NOCOPY VARCHAR2 ) IS
1574:
1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;

Line 1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;

1574:
1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;
1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;

Line 1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id

1575: l_parent_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;
1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;
1583: i NUMBER;

Line 1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;

1576: l_child_deliveries DBMS_UTILITY.NUMBER_ARRAY;
1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;
1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;
1583: i NUMBER;
1584: l_child_details_rated VARCHAR2(1);

Line 1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;

1577: l_parent_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;
1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;
1583: i NUMBER;
1584: l_child_details_rated VARCHAR2(1);
1585: l_consol_LPNs_rated VARCHAR2(1);

Line 1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;

1578: l_child_dlegs DBMS_UTILITY.NUMBER_ARRAY;
1579: l_consol_LPNs DBMS_UTILITY.NUMBER_ARRAY;--Indexed by child detail id
1580: l_consol_LPN_children DBMS_UTILITY.NUMBER_ARRAY;
1581: l_delivery_to_dleg DBMS_UTILITY.NUMBER_ARRAY;
1582: l_dleg_to_delivery DBMS_UTILITY.NUMBER_ARRAY;
1583: i NUMBER;
1584: l_child_details_rated VARCHAR2(1);
1585: l_consol_LPNs_rated VARCHAR2(1);
1586: l_child_dlegs_rated VARCHAR2(1);

Line 5596: l_hash_value := dbms_utility.get_hash_value(

5592: -- {
5593:
5594: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Across - creating hash');
5595: l_hash_string := CONCAT(TO_CHAR(p_rolled_up_lines(i).rate_basis),TO_CHAR(p_rolled_up_lines(i).category_id));
5596: l_hash_value := dbms_utility.get_hash_value(
5597: name => l_hash_string,
5598: base => g_hash_base,
5599: hash_size =>g_hash_size );
5600:

Line 5973: l_hash_value := dbms_utility.get_hash_value(

5969:
5970: -- Is it required for Pricing Objective = NULL
5971: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc => 'Across - creating hash');
5972: l_hash_string := CONCAT(TO_CHAR(x_pricing_engine_rows(i).basis),TO_CHAR(x_pricing_engine_rows(i).category_id));
5973: l_hash_value := dbms_utility.get_hash_value(
5974: name => l_hash_string,
5975: base => g_hash_base,
5976: hash_size =>g_hash_size );
5977:

Line 6076: l_hash_value := dbms_utility.get_hash_value(

6072: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Engine row basis : '||x_pricing_engine_rows(i).basis);
6073: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'rolledup line basis : '||p_rolled_up_lines(j).rate_basis);
6074:
6075: l_hash_string := CONCAT(TO_CHAR(p_rolled_up_lines(j).rate_basis),TO_CHAR(p_rolled_up_lines(j).category_id));
6076: l_hash_value := dbms_utility.get_hash_value(
6077: name => l_hash_string,
6078: base => g_hash_base,
6079: hash_size =>g_hash_size );
6080:

Line 8615: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;

8611: AND charge_source_code = 'PRICING_ENGINE'
8612: FOR UPDATE NOWAIT;
8613:
8614:
8615: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
8616: l_wfc_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
8617:
8618:
8619: BEGIN

Line 8616: l_wfc_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;

8612: FOR UPDATE NOWAIT;
8613:
8614:
8615: l_wfc_detail_ids DBMS_UTILITY.NUMBER_ARRAY;
8616: l_wfc_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
8617:
8618:
8619: BEGIN
8620:

Line 11963: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;

11959: l_freight_cost_main_charge WSH_FREIGHT_COSTS_PVT.Freight_Cost_Rec_Type;
11960: l_price_fc_ids WSH_UTIL_CORE.id_tab_type;
11961: l_rowid VARCHAR2(30);
11962: l_update_rowid VARCHAR2(30);
11963: l_dleg_ids DBMS_UTILITY.NUMBER_ARRAY;
11964: l_delivery_id NUMBER;
11965: l_dleg_id NUMBER;
11966: l_init_msg_list VARCHAR2(30) :=FND_API.G_FALSE;
11967: l_freight_cost_id NUMBER;

Line 13115: l_tl_lane_rows dbms_utility.number_array;

13111: l_sum_lane_price_curr_tab WSH_UTIL_CORE.Column_tab_type;
13112: l_sum_sched_price_tab WSH_UTIL_CORE.id_tab_type;
13113: l_sum_sched_price_curr_tab WSH_UTIL_CORE.Column_tab_type;
13114:
13115: l_tl_lane_rows dbms_utility.number_array;
13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;

Line 13116: l_tl_schedule_rows dbms_utility.number_array;

13112: l_sum_sched_price_tab WSH_UTIL_CORE.id_tab_type;
13113: l_sum_sched_price_curr_tab WSH_UTIL_CORE.Column_tab_type;
13114:
13115: l_tl_lane_rows dbms_utility.number_array;
13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;

Line 13117: l_tl_vehicle_rows dbms_utility.number_array;

13113: l_sum_sched_price_curr_tab WSH_UTIL_CORE.Column_tab_type;
13114:
13115: l_tl_lane_rows dbms_utility.number_array;
13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:

Line 13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;

13114:
13115: l_tl_lane_rows dbms_utility.number_array;
13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;

Line 13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;

13115: l_tl_lane_rows dbms_utility.number_array;
13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;

Line 13120: l_tl_xref dbms_utility.number_array;

13116: l_tl_schedule_rows dbms_utility.number_array;
13117: l_tl_vehicle_rows dbms_utility.number_array;
13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;
13124: l_exploded_vehicle_rows dbms_utility.number_array;

Line 13122: l_exploded_lane_rows dbms_utility.number_array;

13118: l_tl_lane_sched_sum_rows dbms_utility.number_array;
13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;
13124: l_exploded_vehicle_rows dbms_utility.number_array;
13125: l_exploded_ref_rows dbms_utility.number_array;
13126:

Line 13123: l_exploded_schedule_rows dbms_utility.number_array;

13119: l_tl_lane_sched_curr_rows dbms_utility.name_array;
13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;
13124: l_exploded_vehicle_rows dbms_utility.number_array;
13125: l_exploded_ref_rows dbms_utility.number_array;
13126:
13127: l_output_count NUMBER;

Line 13124: l_exploded_vehicle_rows dbms_utility.number_array;

13120: l_tl_xref dbms_utility.number_array;
13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;
13124: l_exploded_vehicle_rows dbms_utility.number_array;
13125: l_exploded_ref_rows dbms_utility.number_array;
13126:
13127: l_output_count NUMBER;
13128: l_ref NUMBER;

Line 13125: l_exploded_ref_rows dbms_utility.number_array;

13121:
13122: l_exploded_lane_rows dbms_utility.number_array;
13123: l_exploded_schedule_rows dbms_utility.number_array;
13124: l_exploded_vehicle_rows dbms_utility.number_array;
13125: l_exploded_ref_rows dbms_utility.number_array;
13126:
13127: l_output_count NUMBER;
13128: l_ref NUMBER;
13129: l_warn_flag VARCHAR2(1);

Line 13130: l_tl_ref dbms_utility.number_array;

13126:
13127: l_output_count NUMBER;
13128: l_ref NUMBER;
13129: l_warn_flag VARCHAR2(1);
13130: l_tl_ref dbms_utility.number_array;
13131: l_lane_xref dbms_utility.number_array;
13132: l_sched_xref dbms_utility.number_array;
13133:
13134: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;

Line 13131: l_lane_xref dbms_utility.number_array;

13127: l_output_count NUMBER;
13128: l_ref NUMBER;
13129: l_warn_flag VARCHAR2(1);
13130: l_tl_ref dbms_utility.number_array;
13131: l_lane_xref dbms_utility.number_array;
13132: l_sched_xref dbms_utility.number_array;
13133:
13134: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
13135:

Line 13132: l_sched_xref dbms_utility.number_array;

13128: l_ref NUMBER;
13129: l_warn_flag VARCHAR2(1);
13130: l_tl_ref dbms_utility.number_array;
13131: l_lane_xref dbms_utility.number_array;
13132: l_sched_xref dbms_utility.number_array;
13133:
13134: l_log_level NUMBER := FTE_FREIGHT_PRICING_UTIL.G_LOG;
13135:
13136: l_ret_stat VARCHAR2(1); -- used only for returning log file name