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 11197: l_freight_cost_main_row.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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