DBA Data[Home] [Help]

APPS.OE_ORDER_ADJ_PVT dependencies on FND_GLOBAL

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

774:
775: -- Get Who Information
776:
777: l_Header_Adj_rec.last_update_date := SYSDATE;
778: l_Header_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
779: l_Header_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
780:
781: IF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
782:

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

775: -- Get Who Information
776:
777: l_Header_Adj_rec.last_update_date := SYSDATE;
778: l_Header_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
779: l_Header_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
780:
781: IF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
782:
783: OE_Header_Adj_Util.Update_Row (l_Header_Adj_rec);

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

784:
785: ELSIF l_Header_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
786:
787: l_Header_Adj_rec.creation_date := SYSDATE;
788: l_Header_Adj_rec.created_by := FND_GLOBAL.USER_ID;
789:
790: OE_Header_Adj_Util.Insert_Row (l_Header_Adj_rec);
791:
792: END IF;

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

1539:
1540: -- Get Who Information
1541:
1542: l_Line_Adj_rec.last_update_date := SYSDATE;
1543: l_Line_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
1544: l_Line_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1545:
1546: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1547: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);

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

1540: -- Get Who Information
1541:
1542: l_Line_Adj_rec.last_update_date := SYSDATE;
1543: l_Line_Adj_rec.last_updated_by := FND_GLOBAL.USER_ID;
1544: l_Line_Adj_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1545:
1546: IF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1547: oe_debug_pub.add(' updating list line id:'||l_Line_Adj_rec.list_line_id);
1548: oe_debug_pub.add(' l_line_adj_rec adjusted_amount:'||l_Line_Adj_rec.adjusted_amount);

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

1551:
1552: ELSIF l_Line_Adj_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1553:
1554: l_Line_Adj_rec.creation_date := SYSDATE;
1555: l_Line_Adj_rec.created_by := FND_GLOBAL.USER_ID;
1556:
1557: adj_debug('Before insert row',2);
1558: OE_Line_Adj_Util.Insert_Row (l_Line_Adj_rec);
1559: adj_debug('After insert row',2);

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

2129:
2130: -- Get Who Information
2131:
2132: l_Header_Price_Att_rec.last_update_date := SYSDATE;
2133: l_Header_Price_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2134: l_Header_Price_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2135:
2136: IF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2137:

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

2130: -- Get Who Information
2131:
2132: l_Header_Price_Att_rec.last_update_date := SYSDATE;
2133: l_Header_Price_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2134: l_Header_Price_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2135:
2136: IF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2137:
2138: OE_Header_PAttr_Util.Update_Row (l_Header_Price_Att_rec);

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

2139:
2140: ELSIF l_Header_Price_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2141:
2142: l_Header_Price_Att_rec.creation_date := SYSDATE;
2143: l_Header_Price_Att_rec.created_by := FND_GLOBAL.USER_ID;
2144: oe_debug_pub.add(' Before calling pattr_util.insert_row');
2145:
2146: select OE_ORDER_PRICE_ATTRIBS_S.nextval
2147: into l_header_price_att_rec.order_price_attrib_id

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

2434:
2435: -- Get Who Information
2436:
2437: l_Header_Adj_Att_rec.last_update_date := SYSDATE;
2438: l_Header_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2439: l_Header_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2441: IF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2442:

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

2435: -- Get Who Information
2436:
2437: l_Header_Adj_Att_rec.last_update_date := SYSDATE;
2438: l_Header_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
2439: l_Header_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2440:
2441: IF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2442:
2443: Oe_Header_Price_Aattr_util.Update_Row (l_Header_Adj_Att_rec);

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

2444:
2445: ELSIF l_Header_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2446:
2447: l_Header_Adj_Att_rec.creation_date := SYSDATE;
2448: l_Header_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
2449:
2450: Oe_Header_Price_Aattr_util.Insert_Row (l_Header_Adj_Att_rec);
2451:
2452: END IF;

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

2713:
2714: -- Get Who Information
2715:
2716: l_Header_Adj_Assoc_rec.last_update_date := SYSDATE;
2717: l_Header_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
2718: l_Header_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2719:
2720: IF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2721:

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

2714: -- Get Who Information
2715:
2716: l_Header_Adj_Assoc_rec.last_update_date := SYSDATE;
2717: l_Header_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
2718: l_Header_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
2719:
2720: IF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2721:
2722: Oe_Header_Adj_Assocs_util.Update_Row (l_Header_Adj_Assoc_rec);

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

2723:
2724: ELSIF l_Header_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2725:
2726: l_Header_Adj_Assoc_rec.creation_date := SYSDATE;
2727: l_Header_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;
2728:
2729: Oe_Header_Adj_Assocs_util.Insert_Row (l_Header_Adj_Assoc_rec);
2730:
2731: END IF;

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

3263: -- Get Who Information
3264:
3265:
3266: l_Line_price_att_rec.last_update_date := SYSDATE;
3267: l_Line_price_att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3268: l_Line_price_att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3269:
3270: IF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3271:

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

3264:
3265:
3266: l_Line_price_att_rec.last_update_date := SYSDATE;
3267: l_Line_price_att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3268: l_Line_price_att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3269:
3270: IF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3271:
3272: OE_Line_Pattr_Util.Update_Row (l_Line_price_att_rec);

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

3273:
3274: ELSIF l_Line_price_att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3275:
3276: l_Line_price_att_rec.creation_date := SYSDATE;
3277: l_Line_price_att_rec.created_by := FND_GLOBAL.USER_ID;
3278:
3279: --BT
3280: --Added the If loop for Bug 3402434
3281: If(l_Line_price_att_rec.order_price_attrib_id is NULL or

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

3610:
3611: -- Get Who Information
3612:
3613: l_Line_Adj_Att_rec.last_update_date := SYSDATE;
3614: l_Line_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3615: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3616:
3617: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3618:

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

3611: -- Get Who Information
3612:
3613: l_Line_Adj_Att_rec.last_update_date := SYSDATE;
3614: l_Line_Adj_Att_rec.last_updated_by := FND_GLOBAL.USER_ID;
3615: l_Line_Adj_Att_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3616:
3617: IF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3618:
3619: Oe_Line_Price_Aattr_util.Update_Row (l_Line_Adj_Att_rec);

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

3620:
3621: ELSIF l_Line_Adj_Att_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3622:
3623: l_Line_Adj_Att_rec.creation_date := SYSDATE;
3624: l_Line_Adj_Att_rec.created_by := FND_GLOBAL.USER_ID;
3625:
3626: Oe_Line_Price_Aattr_util.Insert_Row (l_Line_Adj_Att_rec);
3627:
3628: END IF;

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

3933:
3934: -- Get Who Information
3935:
3936: l_Line_Adj_Assoc_rec.last_update_date := SYSDATE;
3937: l_Line_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
3938: l_Line_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3939:
3940: IF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3941: adj_debug('updating line adj assocs',2);

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

3934: -- Get Who Information
3935:
3936: l_Line_Adj_Assoc_rec.last_update_date := SYSDATE;
3937: l_Line_Adj_Assoc_rec.last_updated_by := FND_GLOBAL.USER_ID;
3938: l_Line_Adj_Assoc_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3939:
3940: IF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3941: adj_debug('updating line adj assocs',2);
3942: Oe_Line_Adj_Assocs_util.Update_Row (l_Line_Adj_Assoc_rec);

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

3943:
3944: ELSIF l_Line_Adj_Assoc_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3945: adj_debug('inserting into line adj assocs',2);
3946: l_Line_Adj_Assoc_rec.creation_date := SYSDATE;
3947: l_Line_Adj_Assoc_rec.created_by := FND_GLOBAL.USER_ID;
3948:
3949: Oe_Line_Adj_Assocs_util.Insert_Row (l_Line_Adj_Assoc_rec);
3950:
3951: END IF;