DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on STANDARD

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 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 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 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 2129: -- 1: Standard/ Model Line

2125: -- service_line identifiers are populated on the record or not.
2126: -- (Item Type is NOT used to derive this information as item_type_code
2127: -- is available only after defaulting)
2128: -- Possible Return Values:
2129: -- 1: Standard/ Model Line
2130: -- 2: Option/Class Line
2131: -- 3: Service Line
2132: ----------------------------------------------------------------------*/
2133: FUNCTION Check_Item_Type

Line 2183: -- STANDARD line if neither the top model line identifiers

2179: END IF;
2180:
2181: ELSE
2182:
2183: -- STANDARD line if neither the top model line identifiers
2184: -- nor the service line identifiers are populated
2185: IF l_debug_level > 0 THEN
2186: oe_debug_pub.add( 'STANDARD LINE' , 1 ) ;
2187: END IF;

Line 2186: oe_debug_pub.add( 'STANDARD LINE' , 1 ) ;

2182:
2183: -- STANDARD line if neither the top model line identifiers
2184: -- nor the service line identifiers are populated
2185: IF l_debug_level > 0 THEN
2186: oe_debug_pub.add( 'STANDARD LINE' , 1 ) ;
2187: END IF;
2188: RETURN 1;
2189:
2190: END IF;

Line 2215: (MODEL, KIT, STANDARD) before we start processing any of the

2211:
2212:
2213: WHY:
2214: 1) We need to process all the top level parents
2215: (MODEL, KIT, STANDARD) before we start processing any of the
2216: child lines. This is because all the child lines refer to the
2217: parent lines using top_model_line_index,
2218: service_reference_line_index etc. and the child lines
2219: processing assumes that all the parents are saved in database

Line 2268: MODE = standard_and_models and check_item_type = 1

2264: if boolean COMPLETE_AND_CLASS_SAVE_MODE is TRUE, we create CLASSES
2265: if it is fales, we create OPTIONS.
2266:
2267:
2268: MODE = standard_and_models and check_item_type = 1
2269: l_process_this_line = TRUE;
2270: ***
2271: IF top model,
2272: IF not called by config UI,

Line 2310: IF MODE = 'MODELS_AND_STANDARD' AND END of lines table(only models,std done)

2306: END IF;
2307:
2308: <> SWITCHING modes.
2309:
2310: IF MODE = 'MODELS_AND_STANDARD' AND END of lines table(only models,std done)
2311: l_mode := 'OPTIONS';
2312: COMPLETE_AND_CLASS_SAVE_MODE := TRUE;
2313: start from the first record again.
2314:

Line 2439: -- standard lines in the table. When models and options are processed in

2435: OE_MSG_PUB.initialize;
2436: END IF;
2437:
2438: -- Looping through the table to first process all the models and
2439: -- standard lines in the table. When models and options are processed in
2440: -- one Process Order Call (like in Copy Order) options do not have
2441: -- top_model_line_id
2442: -- and link_to_line_id populated. Thus the Parent line has to be
2443: -- processed before the

Line 2451: l_mode := 'MODELS_AND_STANDARD' ;

2447: IF l_debug_level > 0 THEN
2448: oe_debug_pub.add( 'G_CONFIG_UI_USED '|| OE_CONFIG_UTIL.G_CONFIG_UI_USED , 5 ) ;
2449: END IF;
2450:
2451: l_mode := 'MODELS_AND_STANDARD' ;
2452:
2453: I := p_x_line_tbl.FIRST;
2454:
2455: WHILE I IS NOT NULL AND l_num_lines > 0

Line 2777: IF (l_mode = 'MODELS_AND_STANDARD') AND

2773: END IF;
2774:
2775:
2776:
2777: IF (l_mode = 'MODELS_AND_STANDARD') AND
2778: l_check_item_type = 1 THEN
2779:
2780: IF l_debug_level > 0 THEN
2781: oe_debug_pub.add( 'L_MODE IS MODELS_AND_STANDARD' , 1 ) ;

Line 2781: oe_debug_pub.add( 'L_MODE IS MODELS_AND_STANDARD' , 1 ) ;

2777: IF (l_mode = 'MODELS_AND_STANDARD') AND
2778: l_check_item_type = 1 THEN
2779:
2780: IF l_debug_level > 0 THEN
2781: oe_debug_pub.add( 'L_MODE IS MODELS_AND_STANDARD' , 1 ) ;
2782: END IF;
2783:
2784: IF OE_Config_Util.G_Config_UI_Used = 'N' AND
2785: l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

Line 2871: END IF; -- mode is standard.

2867: END IF;
2868:
2869: l_process_this_line := TRUE;
2870:
2871: END IF; -- mode is standard.
2872:
2873:
2874: ---------------------- mode is options ----------------------
2875: IF (l_mode = 'OPTIONS') AND

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 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 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 3551: IF (l_mode = 'MODELS_AND_STANDARD') AND (I IS NULL)

3547: END IF;
3548:
3549: I := p_x_line_tbl.NEXT(I);
3550:
3551: IF (l_mode = 'MODELS_AND_STANDARD') AND (I IS NULL)
3552: THEN
3553: I := p_x_line_tbl.FIRST;
3554: l_mode := 'OPTIONS';
3555: COMPLETE_AND_CLASS_SAVE_MODE := TRUE;

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 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 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 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;

Line 8294: -- Standard call to check for call compatibility

8290:
8291: IF l_debug_level > 0 THEN
8292: oe_debug_pub.add( 'ENTERING OE_ORDER_PUB.PROCESS_ORDER' , 1 ) ;
8293: END IF;
8294: -- Standard call to check for call compatibility
8295:
8296: IF NOT FND_API.Compatible_API_Call
8297: ( l_api_version_number
8298: , p_api_version_number

Line 10488: -- Standard call to check for call compatibility

10484:
10485: IF l_debug_level > 0 THEN
10486: oe_debug_pub.add( 'ENTERING OE_ORDER_PVT.LOCK_ORDER' , 1 ) ;
10487: END IF;
10488: -- Standard call to check for call compatibility
10489:
10490: IF NOT FND_API.Compatible_API_Call
10491: ( l_api_version_number
10492: , p_api_version_number

Line 11075: -- Standard call to check for call compatibility

11071: I5 NUMBER; --Used as index.
11072: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11073: BEGIN
11074:
11075: -- Standard call to check for call compatibility
11076:
11077: IF NOT FND_API.Compatible_API_Call
11078: ( l_api_version_number
11079: , p_api_version_number

Line 11413: -- Standard call to check for call compatibility

11409: l_api_name Varchar2(30) := 'CANCEL_ORDER';
11410: l_return_status Varchar2(1);
11411: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11412: Begin
11413: -- Standard call to check for call compatibility
11414:
11415: IF l_debug_level > 0 THEN
11416: oe_debug_pub.add( 'ENTERING OE_ORDER_PUB.CANCEL_ORDER' , 1 ) ;
11417: END IF;