DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on FND_GLOBAL

Line 757: p_x_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

753:
754: -- Get Who Information
755:
756: p_x_header_rec.last_update_date := SYSDATE;
757: p_x_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
758: p_x_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
759:
760: IF p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
761: p_x_header_rec.credit_card_approval_date := NULL;

Line 758: p_x_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

754: -- Get Who Information
755:
756: p_x_header_rec.last_update_date := SYSDATE;
757: p_x_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
758: p_x_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
759:
760: IF p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
761: p_x_header_rec.credit_card_approval_date := NULL;
762: END IF;

Line 774: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

770:
771: ELSIF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
772:
773: p_x_header_rec.creation_date := SYSDATE;
774: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
775:
776: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
777: l_resp_id := FND_GLOBAL.RESP_ID;
778: l_application_id := FND_GLOBAL.RESP_APPL_ID;

Line 776: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

772:
773: p_x_header_rec.creation_date := SYSDATE;
774: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
775:
776: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
777: l_resp_id := FND_GLOBAL.RESP_ID;
778: l_application_id := FND_GLOBAL.RESP_APPL_ID;
779:
780: IF l_debug_level > 0 THEN

Line 777: l_resp_id := FND_GLOBAL.RESP_ID;

773: p_x_header_rec.creation_date := SYSDATE;
774: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
775:
776: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
777: l_resp_id := FND_GLOBAL.RESP_ID;
778: l_application_id := FND_GLOBAL.RESP_APPL_ID;
779:
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'USER ID IS '|| L_USER_ID ) ;

Line 778: l_application_id := FND_GLOBAL.RESP_APPL_ID;

774: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
775:
776: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
777: l_resp_id := FND_GLOBAL.RESP_ID;
778: l_application_id := FND_GLOBAL.RESP_APPL_ID;
779:
780: IF l_debug_level > 0 THEN
781: oe_debug_pub.add( 'USER ID IS '|| L_USER_ID ) ;
782: oe_debug_pub.add( 'RESP ID IS '|| L_RESP_ID ) ;

Line 1304: l_Header_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

1300:
1301: -- Get Who Information
1302:
1303: l_Header_Scredit_rec.last_update_date := SYSDATE;
1304: l_Header_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1305: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1306:
1307: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1308:

Line 1305: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1301: -- Get Who Information
1302:
1303: l_Header_Scredit_rec.last_update_date := SYSDATE;
1304: l_Header_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1305: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1306:
1307: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1308:
1309: OE_Header_Scredit_Util.Update_Row (l_Header_Scredit_rec);

Line 1314: l_Header_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

1310:
1311: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1312:
1313: l_Header_Scredit_rec.creation_date := SYSDATE;
1314: l_Header_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1315:
1316: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);
1317:
1318: END IF;

Line 1961: l_Header_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;

1957:
1958: -- Get Who Information
1959:
1960: l_Header_Payment_rec.last_update_date := SYSDATE;
1961: l_Header_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
1962: l_Header_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1963:
1964: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1965:

Line 1962: l_Header_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

1958: -- Get Who Information
1959:
1960: l_Header_Payment_rec.last_update_date := SYSDATE;
1961: l_Header_Payment_rec.last_updated_by := FND_GLOBAL.USER_ID;
1962: l_Header_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1963:
1964: IF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1965:
1966: OE_Header_Payment_Util.Update_Row (l_Header_Payment_rec);

Line 1971: l_Header_Payment_rec.created_by := FND_GLOBAL.USER_ID;

1967:
1968: ELSIF l_Header_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1969:
1970: l_Header_Payment_rec.creation_date := SYSDATE;
1971: l_Header_Payment_rec.created_by := FND_GLOBAL.USER_ID;
1972:
1973: IF l_debug_level > 0 THEN
1974: oe_debug_pub.add('Payment:before Oe_Header_Payment_Util.Insert_Row', 5);
1975: END IF;

Line 3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

3389:
3390: -- Get Who Information
3391:
3392: l_line_rec.last_update_date := SYSDATE;
3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3396: l_resp_id := FND_GLOBAL.RESP_ID;
3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;

Line 3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

3390: -- Get Who Information
3391:
3392: l_line_rec.last_update_date := SYSDATE;
3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3396: l_resp_id := FND_GLOBAL.RESP_ID;
3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;
3398:

Line 3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

3391:
3392: l_line_rec.last_update_date := SYSDATE;
3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3396: l_resp_id := FND_GLOBAL.RESP_ID;
3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;
3398:
3399: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 3396: l_resp_id := FND_GLOBAL.RESP_ID;

3392: l_line_rec.last_update_date := SYSDATE;
3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3396: l_resp_id := FND_GLOBAL.RESP_ID;
3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;
3398:
3399: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3400: IF l_debug_level > 0 THEN

Line 3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;

3393: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3394: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3395: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3396: l_resp_id := FND_GLOBAL.RESP_ID;
3397: l_application_id := FND_GLOBAL.RESP_APPL_ID;
3398:
3399: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
3400: IF l_debug_level > 0 THEN
3401: oe_debug_pub.add( 'CALLING UPDATE ROW' , 1 ) ;

Line 3409: l_line_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

3405:
3406: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3407:
3408: l_line_rec.creation_date := SYSDATE;
3409: l_line_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3410:
3411: IF l_debug_level > 0 THEN
3412: oe_debug_pub.add( '3.STATUS '||L_LINE_REC.SCHEDULE_STATUS_CODE , 1 ) ;
3413: END IF;

Line 4148: l_Line_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

4144:
4145: -- Get Who Information
4146:
4147: l_Line_Scredit_rec.last_update_date := SYSDATE;
4148: l_Line_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4149: l_Line_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4150:
4151: IF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4152:

Line 4149: l_Line_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

4145: -- Get Who Information
4146:
4147: l_Line_Scredit_rec.last_update_date := SYSDATE;
4148: l_Line_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4149: l_Line_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4150:
4151: IF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4152:
4153: OE_Line_Scredit_Util.Update_Row (l_Line_Scredit_rec);

Line 4158: l_Line_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

4154:
4155: ELSIF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4156:
4157: l_Line_Scredit_rec.creation_date := SYSDATE;
4158: l_Line_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4159:
4160: OE_Line_Scredit_Util.Insert_Row (l_Line_Scredit_rec);
4161:
4162: END IF;

Line 4804: l_Line_Payment_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

4800:
4801: -- Get Who Information
4802:
4803: l_Line_Payment_rec.last_update_date := SYSDATE;
4804: l_Line_Payment_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4805: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4806:
4807: IF l_Line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4808:

Line 4805: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

4801: -- Get Who Information
4802:
4803: l_Line_Payment_rec.last_update_date := SYSDATE;
4804: l_Line_Payment_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4805: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4806:
4807: IF l_Line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4808:
4809: IF l_debug_level > 0 THEN

Line 4820: l_Line_Payment_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

4816:
4817: ELSIF l_Line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4818:
4819: l_Line_Payment_rec.creation_date := SYSDATE;
4820: l_Line_Payment_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4821:
4822: IF l_debug_level > 0 THEN
4823: oe_debug_pub.add('Payment:before OE_Line_Payment_Util.Insert_Row', 5);
4824: END IF;

Line 5169: l_Lot_Serial_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

5165:
5166: -- Get Who Information
5167:
5168: l_Lot_Serial_rec.last_update_date := SYSDATE;
5169: l_Lot_Serial_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5170: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
5171:
5172: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5173:

Line 5170: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;

5166: -- Get Who Information
5167:
5168: l_Lot_Serial_rec.last_update_date := SYSDATE;
5169: l_Lot_Serial_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5170: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
5171:
5172: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5173:
5174: OE_Lot_Serial_Util.Update_Row (l_Lot_Serial_rec);

Line 5179: l_Lot_Serial_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637

5175:
5176: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5177:
5178: l_Lot_Serial_rec.creation_date := SYSDATE;
5179: l_Lot_Serial_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5180:
5181: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);
5182:
5183: END IF;