DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on FND_GLOBAL

Line 743: l_Header_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;

739:
740: -- Get Who Information
741:
742: l_Header_Adj_rec.last_update_date := SYSDATE;
743: l_Header_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
744: l_Header_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
745:
746: IF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
747:

Line 744: l_Header_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

740: -- Get Who Information
741:
742: l_Header_Adj_rec.last_update_date := SYSDATE;
743: l_Header_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
744: l_Header_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
745:
746: IF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
747:
748: OE_Header_Adj_Util.Update_Row (l_Header_Adj_rec);

Line 753: l_Header_Adj_rec.created_by := FND_GLOBAL.USER_ID;

749:
750: ELSIF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
751:
752: l_Header_Adj_rec.creation_date := SYSDATE;
753: l_Header_Adj_rec.created_by := FND_GLOBAL.USER_ID;
754:
755: OE_Header_Adj_Util.Insert_Row (l_Header_Adj_rec);
756:
757: END IF;

Line 1460: l_Line_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;

1456:
1457: -- Get Who Information
1458:
1459: l_Line_Adj_rec.last_update_date := SYSDATE;
1460: l_Line_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
1461: l_Line_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1462:
1463: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1464: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);

Line 1461: l_Line_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1457: -- Get Who Information
1458:
1459: l_Line_Adj_rec.last_update_date := SYSDATE;
1460: l_Line_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
1461: l_Line_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1462:
1463: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1464: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);
1465: oe_debug_pub.add(' l_line_adj_rec adjusted_amount:'||l_Line_Adj_rec.adjusted_amount);

Line 1472: l_Line_Adj_rec.created_by := FND_GLOBAL.USER_ID;

1468:
1469: ELSIF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1470:
1471: l_Line_Adj_rec.creation_date := SYSDATE;
1472: l_Line_Adj_rec.created_by := FND_GLOBAL.USER_ID;
1473:
1474: adj_debug('Before insert row',2);
1475: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);
1476: adj_debug('After insert row',2);

Line 2050: l_Header_Price_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;

2046:
2047: -- Get Who Information
2048:
2049: l_Header_Price_Att_rec.last_update_date := SYSDATE;
2050: l_Header_Price_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2051: l_Header_Price_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2052:
2053: IF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2054:

Line 2051: l_Header_Price_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

2047: -- Get Who Information
2048:
2049: l_Header_Price_Att_rec.last_update_date := SYSDATE;
2050: l_Header_Price_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2051: l_Header_Price_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2052:
2053: IF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2054:
2055: OE_Header_PAttr_Util.Update_Row (l_Header_Price_Att_rec);

Line 2060: l_Header_Price_Att_rec.created_by := FND_GLOBAL.USER_ID;

2056:
2057: ELSIF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2058:
2059: l_Header_Price_Att_rec.creation_date := SYSDATE;
2060: l_Header_Price_Att_rec.created_by := FND_GLOBAL.USER_ID;
2061: oe_debug_pub.add(' Before calling pattr_util.insert_row');
2062:
2063: select OE_ORDER_PRICE_ATTRIBS_S.nextval
2064: into l_header_price_att_rec.order_price_attrib_id

Line 2355: l_Header_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;

2351:
2352: -- Get Who Information
2353:
2354: l_Header_Adj_Att_rec.last_update_date := SYSDATE;
2355: l_Header_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2356: l_Header_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2357:
2358: IF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2359:

Line 2356: l_Header_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

2352: -- Get Who Information
2353:
2354: l_Header_Adj_Att_rec.last_update_date := SYSDATE;
2355: l_Header_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2356: l_Header_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2357:
2358: IF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2359:
2360: Oe_Header_Price_Aattr_util.Update_Row (l_Header_Adj_Att_rec);

Line 2365: l_Header_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;

2361:
2362: ELSIF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2363:
2364: l_Header_Adj_Att_rec.creation_date := SYSDATE;
2365: l_Header_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
2366:
2367: Oe_Header_Price_Aattr_util.Insert_Row (l_Header_Adj_Att_rec);
2368:
2369: END IF;

Line 2634: l_Header_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;

2630:
2631: -- Get Who Information
2632:
2633: l_Header_Adj_Assoc_rec.last_update_date := SYSDATE;
2634: l_Header_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
2635: l_Header_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2636:
2637: IF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2638:

Line 2635: l_Header_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

2631: -- Get Who Information
2632:
2633: l_Header_Adj_Assoc_rec.last_update_date := SYSDATE;
2634: l_Header_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
2635: l_Header_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2636:
2637: IF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2638:
2639: Oe_Header_Adj_Assocs_util.Update_Row (l_Header_Adj_Assoc_rec);

Line 2644: l_Header_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;

2640:
2641: ELSIF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2642:
2643: l_Header_Adj_Assoc_rec.creation_date := SYSDATE;
2644: l_Header_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;
2645:
2646: Oe_Header_Adj_Assocs_util.Insert_Row (l_Header_Adj_Assoc_rec);
2647:
2648: END IF;

Line 3184: l_Line_price_att_rec.last_updated_by := FND_GLOBAL.USER_ID;

3180: -- Get Who Information
3181:
3182:
3183: l_Line_price_att_rec.last_update_date := SYSDATE;
3184: l_Line_price_att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3185: l_Line_price_att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3186:
3187: IF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3188:

Line 3185: l_Line_price_att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

3181:
3182:
3183: l_Line_price_att_rec.last_update_date := SYSDATE;
3184: l_Line_price_att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3185: l_Line_price_att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3186:
3187: IF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3188:
3189: OE_Line_Pattr_Util.Update_Row (l_Line_price_att_rec);

Line 3194: l_Line_price_att_rec.created_by := FND_GLOBAL.USER_ID;

3190:
3191: ELSIF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3192:
3193: l_Line_price_att_rec.creation_date := SYSDATE;
3194: l_Line_price_att_rec.created_by := FND_GLOBAL.USER_ID;
3195:
3196: --BT
3197: --Added the If loop for Bug 3402434
3198: If(l_Line_price_att_rec.order_price_attrib_id is NULL or

Line 3531: l_Line_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;

3527:
3528: -- Get Who Information
3529:
3530: l_Line_Adj_Att_rec.last_update_date := SYSDATE;
3531: l_Line_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3532: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3533:
3534: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3535:

Line 3532: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

3528: -- Get Who Information
3529:
3530: l_Line_Adj_Att_rec.last_update_date := SYSDATE;
3531: l_Line_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3532: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3533:
3534: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3535:
3536: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);

Line 3541: l_Line_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;

3537:
3538: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3539:
3540: l_Line_Adj_Att_rec.creation_date := SYSDATE;
3541: l_Line_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
3542:
3543: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);
3544:
3545: END IF;

Line 3854: l_Line_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;

3850:
3851: -- Get Who Information
3852:
3853: l_Line_Adj_Assoc_rec.last_update_date := SYSDATE;
3854: l_Line_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
3855: l_Line_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3856:
3857: IF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3858: adj_debug('updating line adj assocs',2);

Line 3855: l_Line_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

3851: -- Get Who Information
3852:
3853: l_Line_Adj_Assoc_rec.last_update_date := SYSDATE;
3854: l_Line_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
3855: l_Line_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3856:
3857: IF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3858: adj_debug('updating line adj assocs',2);
3859: Oe_Line_Adj_Assocs_util.Update_Row (l_Line_Adj_Assoc_rec);

Line 3864: l_Line_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;

3860:
3861: ELSIF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3862: adj_debug('inserting into line adj assocs',2);
3863: l_Line_Adj_Assoc_rec.creation_date := SYSDATE;
3864: l_Line_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;
3865:
3866: Oe_Line_Adj_Assocs_util.Insert_Row (l_Line_Adj_Assoc_rec);
3867:
3868: END IF;