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 FND_GLOBAL

Line 7829: l_freight_cost_temp_price(k).created_by := FND_GLOBAL.USER_ID;

7825: k := l_freight_cost_temp_price.FIRST;
7826: IF k is NOT NULL THEN
7827: LOOP
7828: l_freight_cost_temp_price(k).creation_date := SYSDATE;
7829: l_freight_cost_temp_price(k).created_by := FND_GLOBAL.USER_ID;
7830: l_freight_cost_temp_price(k).last_update_date := sysdate;
7831: l_freight_cost_temp_price(k).last_updated_by := FND_GLOBAL.USER_ID;
7832: l_freight_cost_temp_price(k).last_update_login := FND_GLOBAL.LOGIN_ID;
7833: l_freight_cost_temp_price(k).comparison_request_id := p_request_id;

Line 7831: l_freight_cost_temp_price(k).last_updated_by := FND_GLOBAL.USER_ID;

7827: LOOP
7828: l_freight_cost_temp_price(k).creation_date := SYSDATE;
7829: l_freight_cost_temp_price(k).created_by := FND_GLOBAL.USER_ID;
7830: l_freight_cost_temp_price(k).last_update_date := sysdate;
7831: l_freight_cost_temp_price(k).last_updated_by := FND_GLOBAL.USER_ID;
7832: l_freight_cost_temp_price(k).last_update_login := FND_GLOBAL.LOGIN_ID;
7833: l_freight_cost_temp_price(k).comparison_request_id := p_request_id;
7834:
7835: IF p_schedule_id IS NULL THEN

Line 7832: l_freight_cost_temp_price(k).last_update_login := FND_GLOBAL.LOGIN_ID;

7828: l_freight_cost_temp_price(k).creation_date := SYSDATE;
7829: l_freight_cost_temp_price(k).created_by := FND_GLOBAL.USER_ID;
7830: l_freight_cost_temp_price(k).last_update_date := sysdate;
7831: l_freight_cost_temp_price(k).last_updated_by := FND_GLOBAL.USER_ID;
7832: l_freight_cost_temp_price(k).last_update_login := FND_GLOBAL.LOGIN_ID;
7833: l_freight_cost_temp_price(k).comparison_request_id := p_request_id;
7834:
7835: IF p_schedule_id IS NULL THEN
7836: l_freight_cost_temp_price(k).lane_id := p_lane_id; -- Need to insert schedule_id/lane_id

Line 7895: l_freight_cost_temp_charge(n).created_by := FND_GLOBAL.USER_ID;

7891: n := l_freight_cost_temp_charge.FIRST;
7892: IF n IS NOT NULL THEN
7893: LOOP
7894: l_freight_cost_temp_charge(n).creation_date := SYSDATE;
7895: l_freight_cost_temp_charge(n).created_by := FND_GLOBAL.USER_ID;
7896: l_freight_cost_temp_charge(n).last_update_date := sysdate;
7897: l_freight_cost_temp_charge(n).last_updated_by := FND_GLOBAL.USER_ID;
7898: l_freight_cost_temp_charge(n).last_update_login := FND_GLOBAL.LOGIN_ID;
7899: l_freight_cost_temp_charge(n).comparison_request_id := p_request_id;

Line 7897: l_freight_cost_temp_charge(n).last_updated_by := FND_GLOBAL.USER_ID;

7893: LOOP
7894: l_freight_cost_temp_charge(n).creation_date := SYSDATE;
7895: l_freight_cost_temp_charge(n).created_by := FND_GLOBAL.USER_ID;
7896: l_freight_cost_temp_charge(n).last_update_date := sysdate;
7897: l_freight_cost_temp_charge(n).last_updated_by := FND_GLOBAL.USER_ID;
7898: l_freight_cost_temp_charge(n).last_update_login := FND_GLOBAL.LOGIN_ID;
7899: l_freight_cost_temp_charge(n).comparison_request_id := p_request_id;
7900:
7901: IF p_schedule_id IS NULL THEN

Line 7898: l_freight_cost_temp_charge(n).last_update_login := FND_GLOBAL.LOGIN_ID;

7894: l_freight_cost_temp_charge(n).creation_date := SYSDATE;
7895: l_freight_cost_temp_charge(n).created_by := FND_GLOBAL.USER_ID;
7896: l_freight_cost_temp_charge(n).last_update_date := sysdate;
7897: l_freight_cost_temp_charge(n).last_updated_by := FND_GLOBAL.USER_ID;
7898: l_freight_cost_temp_charge(n).last_update_login := FND_GLOBAL.LOGIN_ID;
7899: l_freight_cost_temp_charge(n).comparison_request_id := p_request_id;
7900:
7901: IF p_schedule_id IS NULL THEN
7902: l_freight_cost_temp_charge(n).lane_id := p_lane_id; -- Need to insert schedule_id/lane_id

Line 7954: l_fc_main_update_rows(l).last_updated_by := FND_GLOBAL.USER_ID;

7950: -- For now
7951: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Update row delivery leg id : '||l_fc_main_update_rows(l).delivery_leg_id);
7952:
7953: l_fc_main_update_rows(l).last_update_date := sysdate;
7954: l_fc_main_update_rows(l).last_updated_by := FND_GLOBAL.USER_ID;
7955: l_fc_main_update_rows(l).last_update_login := FND_GLOBAL.LOGIN_ID;
7956: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
7957: p_rowid => l_rowid,
7958: p_freight_cost_info => l_fc_main_update_rows(l),

Line 7955: l_fc_main_update_rows(l).last_update_login := FND_GLOBAL.LOGIN_ID;

7951: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Update row delivery leg id : '||l_fc_main_update_rows(l).delivery_leg_id);
7952:
7953: l_fc_main_update_rows(l).last_update_date := sysdate;
7954: l_fc_main_update_rows(l).last_updated_by := FND_GLOBAL.USER_ID;
7955: l_fc_main_update_rows(l).last_update_login := FND_GLOBAL.LOGIN_ID;
7956: WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost(
7957: p_rowid => l_rowid,
7958: p_freight_cost_info => l_fc_main_update_rows(l),
7959: x_return_status => l_return_status);

Line 7983: l_freight_cost_main_price(m).created_by := FND_GLOBAL.USER_ID;

7979: IF m IS NOT NULL THEN
7980: LOOP
7981: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Create base price delivery detail id : '||l_freight_cost_main_price(m).delivery_detail_id);
7982: l_freight_cost_main_price(m).creation_date := SYSDATE;
7983: l_freight_cost_main_price(m).created_by := FND_GLOBAL.USER_ID;
7984: l_freight_cost_main_price(m).last_update_date := sysdate;
7985: l_freight_cost_main_price(m).last_updated_by := FND_GLOBAL.USER_ID;
7986: l_freight_cost_main_price(m).last_update_login := FND_GLOBAL.LOGIN_ID;
7987:

Line 7985: l_freight_cost_main_price(m).last_updated_by := FND_GLOBAL.USER_ID;

7981: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Create base price delivery detail id : '||l_freight_cost_main_price(m).delivery_detail_id);
7982: l_freight_cost_main_price(m).creation_date := SYSDATE;
7983: l_freight_cost_main_price(m).created_by := FND_GLOBAL.USER_ID;
7984: l_freight_cost_main_price(m).last_update_date := sysdate;
7985: l_freight_cost_main_price(m).last_updated_by := FND_GLOBAL.USER_ID;
7986: l_freight_cost_main_price(m).last_update_login := FND_GLOBAL.LOGIN_ID;
7987:
7988: -- pack J enhancement for FPA --
7989: IF ( l_freight_cost_main_price(m).delivery_detail_id IS NOT NULL

Line 7986: l_freight_cost_main_price(m).last_update_login := FND_GLOBAL.LOGIN_ID;

7982: l_freight_cost_main_price(m).creation_date := SYSDATE;
7983: l_freight_cost_main_price(m).created_by := FND_GLOBAL.USER_ID;
7984: l_freight_cost_main_price(m).last_update_date := sysdate;
7985: l_freight_cost_main_price(m).last_updated_by := FND_GLOBAL.USER_ID;
7986: l_freight_cost_main_price(m).last_update_login := FND_GLOBAL.LOGIN_ID;
7987:
7988: -- pack J enhancement for FPA --
7989: IF ( l_freight_cost_main_price(m).delivery_detail_id IS NOT NULL
7990: AND g_rolledup_lines.EXISTS(l_freight_cost_main_price(m).delivery_detail_id)

Line 8030: l_freight_cost_main_charge(o).created_by := FND_GLOBAL.USER_ID;

8026: IF o IS NOT NULL THEN
8027: LOOP
8028: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Create charge delivery detail id : '||l_freight_cost_main_charge(o).delivery_detail_id);
8029: l_freight_cost_main_charge(o).creation_date := SYSDATE;
8030: l_freight_cost_main_charge(o).created_by := FND_GLOBAL.USER_ID;
8031: l_freight_cost_main_charge(o).last_update_date := sysdate;
8032: l_freight_cost_main_charge(o).last_updated_by := FND_GLOBAL.USER_ID;
8033: l_freight_cost_main_charge(o).last_update_login := FND_GLOBAL.LOGIN_ID;
8034: l_freight_cost_main_charge(o).applied_to_charge_id := l_freight_cost_main_ids(l_freight_cost_main_charge(o).delivery_detail_id); -- For a delivery detail there is only one base price to which any charge gets applied to

Line 8032: l_freight_cost_main_charge(o).last_updated_by := FND_GLOBAL.USER_ID;

8028: FTE_FREIGHT_PRICING_UTIL.print_msg(FTE_FREIGHT_PRICING_UTIL.G_DBG,'Create charge delivery detail id : '||l_freight_cost_main_charge(o).delivery_detail_id);
8029: l_freight_cost_main_charge(o).creation_date := SYSDATE;
8030: l_freight_cost_main_charge(o).created_by := FND_GLOBAL.USER_ID;
8031: l_freight_cost_main_charge(o).last_update_date := sysdate;
8032: l_freight_cost_main_charge(o).last_updated_by := FND_GLOBAL.USER_ID;
8033: l_freight_cost_main_charge(o).last_update_login := FND_GLOBAL.LOGIN_ID;
8034: l_freight_cost_main_charge(o).applied_to_charge_id := l_freight_cost_main_ids(l_freight_cost_main_charge(o).delivery_detail_id); -- For a delivery detail there is only one base price to which any charge gets applied to
8035:
8036: -- pack J enhancement for FPA --

Line 8033: l_freight_cost_main_charge(o).last_update_login := FND_GLOBAL.LOGIN_ID;

8029: l_freight_cost_main_charge(o).creation_date := SYSDATE;
8030: l_freight_cost_main_charge(o).created_by := FND_GLOBAL.USER_ID;
8031: l_freight_cost_main_charge(o).last_update_date := sysdate;
8032: l_freight_cost_main_charge(o).last_updated_by := FND_GLOBAL.USER_ID;
8033: l_freight_cost_main_charge(o).last_update_login := FND_GLOBAL.LOGIN_ID;
8034: l_freight_cost_main_charge(o).applied_to_charge_id := l_freight_cost_main_ids(l_freight_cost_main_charge(o).delivery_detail_id); -- For a delivery detail there is only one base price to which any charge gets applied to
8035:
8036: -- pack J enhancement for FPA --
8037: IF ( l_freight_cost_main_charge(o).delivery_detail_id IS NOT NULL

Line 11198: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

11194: l_freight_cost_main_row.CHARGE_SOURCE_CODE := p_freight_cost_temp_price(i).CHARGE_SOURCE_CODE;
11195: --l_freight_cost_main_row.ESTIMATED_FLAG := p_freight_cost_temp_price(i).ESTIMATED_FLAG;
11196: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11197: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11198: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11199: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11200: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11201: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_price(i).BILLABLE_UOM;
11202: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_price(i).BILLABLE_BASIS;

Line 11199: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

11195: --l_freight_cost_main_row.ESTIMATED_FLAG := p_freight_cost_temp_price(i).ESTIMATED_FLAG;
11196: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11197: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11198: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11199: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11200: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11201: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_price(i).BILLABLE_UOM;
11202: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_price(i).BILLABLE_BASIS;
11203: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_price(i).BILLABLE_QUANTITY;

Line 11200: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

11196: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11197: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11198: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11199: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11200: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11201: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_price(i).BILLABLE_UOM;
11202: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_price(i).BILLABLE_BASIS;
11203: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_price(i).BILLABLE_QUANTITY;
11204: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

Line 11204: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

11200: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11201: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_price(i).BILLABLE_UOM;
11202: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_price(i).BILLABLE_BASIS;
11203: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_price(i).BILLABLE_QUANTITY;
11204: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11205: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
11206:
11207: -- pack J Enhancement for FPA
11208: l_freight_cost_main_row.COMMODITY_CATEGORY_ID

Line 11247: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;

11243:
11244: ELSE
11245:
11246: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11247: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11248:
11249: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11250: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11251: p_freight_cost_info => l_freight_cost_main_row,

Line 11301: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;

11297: l_freight_cost_main_charge.CHARGE_SOURCE_CODE := p_freight_cost_temp_charge(i).CHARGE_SOURCE_CODE;
11298: --l_freight_cost_main_charge.ESTIMATED_FLAG := p_freight_cost_temp_charge(i).ESTIMATED_FLAG;
11299: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
11300: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11301: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11302: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11303: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11304: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11305: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

Line 11303: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

11299: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
11300: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11301: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11302: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11303: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11304: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11305: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11306: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_charge(i).BILLABLE_UOM;
11307: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_charge(i).BILLABLE_BASIS;

Line 11304: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

11300: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11301: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11302: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11303: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11304: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11305: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11306: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_charge(i).BILLABLE_UOM;
11307: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_charge(i).BILLABLE_BASIS;
11308: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_charge(i).BILLABLE_QUANTITY;

Line 11305: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

11301: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11302: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11303: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11304: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11305: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11306: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_charge(i).BILLABLE_UOM;
11307: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_charge(i).BILLABLE_BASIS;
11308: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_charge(i).BILLABLE_QUANTITY;
11309:

Line 11310: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

11306: l_freight_cost_main_row.BILLABLE_UOM := p_freight_cost_temp_charge(i).BILLABLE_UOM;
11307: l_freight_cost_main_row.BILLABLE_BASIS := p_freight_cost_temp_charge(i).BILLABLE_BASIS;
11308: l_freight_cost_main_row.BILLABLE_QUANTITY := p_freight_cost_temp_charge(i).BILLABLE_QUANTITY;
11309:
11310: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11311: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
11312:
11313: -- pack J Enhancement for FPA
11314: l_freight_cost_main_charge.COMMODITY_CATEGORY_ID

Line 11418: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

11414: l_freight_cost_main_row.CHARGE_SOURCE_CODE := p_freight_cost_temp(i).CHARGE_SOURCE_CODE;
11415: --l_freight_cost_main_row.ESTIMATED_FLAG := p_freight_cost_temp(i).ESTIMATED_FLAG;
11416: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11417: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11418: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11419: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11420: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11421: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11422: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;

Line 11419: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

11415: --l_freight_cost_main_row.ESTIMATED_FLAG := p_freight_cost_temp(i).ESTIMATED_FLAG;
11416: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11417: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11418: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11419: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11420: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11421: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11422: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
11423:

Line 11420: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

11416: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11417: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11418: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11419: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11420: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11421: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11422: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
11423:
11424: -- pack J Enhancement for FPA

Line 11421: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

11417: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11418: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11419: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11420: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11421: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11422: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
11423:
11424: -- pack J Enhancement for FPA
11425: l_freight_cost_main_row.COMMODITY_CATEGORY_ID

Line 11463: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;

11459:
11460: ELSE
11461:
11462: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11463: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11464:
11465: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'Calling WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost...');
11466: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11467: p_freight_cost_info => l_freight_cost_main_row,

Line 11672: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

11668: l_freight_cost_main_row.CHARGE_SOURCE_CODE := l_freight_cost_temp_row.CHARGE_SOURCE_CODE;
11669: --l_freight_cost_main_row.ESTIMATED_FLAG := l_freight_cost_temp_row.ESTIMATED_FLAG;
11670: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11671: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11672: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11673: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11674: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11675: -- Added for R12
11676: l_freight_cost_main_row.BILLABLE_QUANTITY := l_freight_cost_temp_row.BILLABLE_QUANTITY;

Line 11673: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

11669: --l_freight_cost_main_row.ESTIMATED_FLAG := l_freight_cost_temp_row.ESTIMATED_FLAG;
11670: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11671: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11672: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11673: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11674: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11675: -- Added for R12
11676: l_freight_cost_main_row.BILLABLE_QUANTITY := l_freight_cost_temp_row.BILLABLE_QUANTITY;
11677: l_freight_cost_main_row.BILLABLE_UOM := l_freight_cost_temp_row.BILLABLE_UOM;

Line 11674: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

11670: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
11671: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
11672: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11673: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11674: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11675: -- Added for R12
11676: l_freight_cost_main_row.BILLABLE_QUANTITY := l_freight_cost_temp_row.BILLABLE_QUANTITY;
11677: l_freight_cost_main_row.BILLABLE_UOM := l_freight_cost_temp_row.BILLABLE_UOM;
11678: l_freight_cost_main_row.BILLABLE_BASIS := l_freight_cost_temp_row.BILLABLE_BASIS;

Line 11680: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

11676: l_freight_cost_main_row.BILLABLE_QUANTITY := l_freight_cost_temp_row.BILLABLE_QUANTITY;
11677: l_freight_cost_main_row.BILLABLE_UOM := l_freight_cost_temp_row.BILLABLE_UOM;
11678: l_freight_cost_main_row.BILLABLE_BASIS := l_freight_cost_temp_row.BILLABLE_BASIS;
11679:
11680: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11681: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
11682:
11683: -- pack J Enhancement for FPA
11684: l_freight_cost_main_row.COMMODITY_CATEGORY_ID

Line 11694: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;

11690: OR (l_freight_cost_main_row.line_type_code = 'SUMMARY'
11691: AND l_freight_cost_main_row.delivery_detail_id IS NOT NULL) THEN
11692:
11693: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
11694: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
11695:
11696: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
11697: p_freight_cost_info => l_freight_cost_main_row,
11698: x_rowid => l_rowid,

Line 11777: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;

11773: l_freight_cost_main_charge.CHARGE_SOURCE_CODE := l_freight_cost_temp_charge.CHARGE_SOURCE_CODE;
11774: --l_freight_cost_main_charge.ESTIMATED_FLAG := l_freight_cost_temp_charge.ESTIMATED_FLAG;
11775: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
11776: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11777: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11778: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

Line 11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

11775: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
11776: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11777: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11778: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11782: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11783: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;

Line 11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

11776: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
11777: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11778: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11782: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11783: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
11784:

Line 11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

11777: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
11778: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11782: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11783: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
11784:
11785:

Line 11782: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

11778: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
11779: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
11780: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
11781: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
11782: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
11783: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
11784:
11785:
11786:

Line 12075: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

12071: l_freight_cost_main_row.CHARGE_SOURCE_CODE := l_freight_cost_temp_row.CHARGE_SOURCE_CODE;
12072: --l_freight_cost_main_row.ESTIMATED_FLAG := l_freight_cost_temp_row.ESTIMATED_FLAG;
12073: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
12074: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
12075: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12076: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12077: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12078: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12079: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;

Line 12076: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

12072: --l_freight_cost_main_row.ESTIMATED_FLAG := l_freight_cost_temp_row.ESTIMATED_FLAG;
12073: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
12074: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
12075: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12076: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12077: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12078: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12079: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
12080:

Line 12077: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

12073: l_freight_cost_main_row.ESTIMATED_FLAG := 'Y';
12074: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
12075: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12076: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12077: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12078: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12079: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
12080:
12081: -- Added for R12

Line 12078: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

12074: l_freight_cost_main_row.LAST_UPDATE_DATE := SYSDATE;
12075: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12076: l_freight_cost_main_row.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12077: l_freight_cost_main_row.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12078: --l_freight_cost_main_row.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12079: --l_freight_cost_main_row.PROGRAM_UPDATE_DATE := SYSDATE;
12080:
12081: -- Added for R12
12082: l_freight_cost_main_row.BILLABLE_QUANTITY := l_freight_cost_temp_row.BILLABLE_QUANTITY;

Line 12097: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;

12093: OR (l_freight_cost_main_row.line_type_code = 'SUMMARY'
12094: AND l_freight_cost_main_row.delivery_detail_id IS NOT NULL) THEN
12095:
12096: l_freight_cost_main_row.CREATION_DATE := SYSDATE;
12097: l_freight_cost_main_row.CREATED_BY := FND_GLOBAL.USER_ID;
12098:
12099: WSH_FREIGHT_COSTS_PVT.Create_Freight_Cost(
12100: p_freight_cost_info => l_freight_cost_main_row,
12101: x_rowid => l_rowid,

Line 12196: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;

12192: l_freight_cost_main_charge.CHARGE_SOURCE_CODE := l_freight_cost_temp_charge.CHARGE_SOURCE_CODE;
12193: --l_freight_cost_main_charge.ESTIMATED_FLAG := l_freight_cost_temp_charge.ESTIMATED_FLAG;
12194: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
12195: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
12196: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
12197: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

Line 12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

12194: l_freight_cost_main_charge.ESTIMATED_FLAG := 'Y';
12195: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
12196: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
12197: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12201: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12202: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;

Line 12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

12195: l_freight_cost_main_charge.CREATION_DATE := SYSDATE;
12196: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
12197: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12201: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12202: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
12203:

Line 12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;

12196: l_freight_cost_main_charge.CREATED_BY := FND_GLOBAL.USER_ID;
12197: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12201: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12202: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
12203:
12204:

Line 12201: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;

12197: l_freight_cost_main_charge.LAST_UPDATE_DATE := SYSDATE;
12198: l_freight_cost_main_charge.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
12199: l_freight_cost_main_charge.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
12200: l_freight_cost_main_charge.PROGRAM_APPLICATION_ID := FND_GLOBAL.PROG_APPL_ID;
12201: --l_freight_cost_main_charge.PROGRAM_ID := FND_GLOBAL.CONC_PROGRAM_ID;
12202: --l_freight_cost_main_charge.PROGRAM_UPDATE_DATE := SYSDATE;
12203:
12204:
12205: -- pack J Enhancement for FPA