DBA Data[Home] [Help]

APPS.OE_ORDER_PVT dependencies on STANDARD

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

790:
791: -- Get Who Information
792:
793: p_x_header_rec.last_update_date := SYSDATE;
794: p_x_header_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
795: p_x_header_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
796:
797: IF p_x_header_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN
798: p_x_header_rec.credit_card_approval_date := NULL;

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

807:
808: ELSIF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
809:
810: p_x_header_rec.creation_date := SYSDATE;
811: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
812:
813: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
814: l_resp_id := FND_GLOBAL.RESP_ID;
815: l_application_id := FND_GLOBAL.RESP_APPL_ID;

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

809:
810: p_x_header_rec.creation_date := SYSDATE;
811: p_x_header_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
812:
813: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
814: l_resp_id := FND_GLOBAL.RESP_ID;
815: l_application_id := FND_GLOBAL.RESP_APPL_ID;
816:
817: IF l_debug_level > 0 THEN

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

1337:
1338: -- Get Who Information
1339:
1340: l_Header_Scredit_rec.last_update_date := SYSDATE;
1341: l_Header_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1342: l_Header_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
1343:
1344: IF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1345:

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

1347:
1348: ELSIF l_Header_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1349:
1350: l_Header_Scredit_rec.creation_date := SYSDATE;
1351: l_Header_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
1352:
1353: OE_Header_Scredit_Util.Insert_Row (l_Header_Scredit_rec);
1354:
1355: END IF;

Line 2166: -- 1: Standard/ Model Line

2162: -- service_line identifiers are populated on the record or not.
2163: -- (Item Type is NOT used to derive this information as item_type_code
2164: -- is available only after defaulting)
2165: -- Possible Return Values:
2166: -- 1: Standard/ Model Line
2167: -- 2: Option/Class Line
2168: -- 3: Service Line
2169: ----------------------------------------------------------------------*/
2170: FUNCTION Check_Item_Type

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

2216: END IF;
2217:
2218: ELSE
2219:
2220: -- STANDARD line if neither the top model line identifiers
2221: -- nor the service line identifiers are populated
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'STANDARD LINE' , 1 ) ;
2224: END IF;

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

2219:
2220: -- STANDARD line if neither the top model line identifiers
2221: -- nor the service line identifiers are populated
2222: IF l_debug_level > 0 THEN
2223: oe_debug_pub.add( 'STANDARD LINE' , 1 ) ;
2224: END IF;
2225: RETURN 1;
2226:
2227: END IF;

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

2248:
2249:
2250: WHY:
2251: 1) We need to process all the top level parents
2252: (MODEL, KIT, STANDARD) before we start processing any of the
2253: child lines. This is because all the child lines refer to the
2254: parent lines using top_model_line_index,
2255: service_reference_line_index etc. and the child lines
2256: processing assumes that all the parents are saved in database

Line 2305: MODE = standard_and_models and check_item_type = 1

2301: if boolean COMPLETE_AND_CLASS_SAVE_MODE is TRUE, we create CLASSES
2302: if it is fales, we create OPTIONS.
2303:
2304:
2305: MODE = standard_and_models and check_item_type = 1
2306: l_process_this_line = TRUE;
2307: ***
2308: IF top model,
2309: IF not called by config UI,

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

2343: END IF;
2344:
2345: <> SWITCHING modes.
2346:
2347: IF MODE = 'MODELS_AND_STANDARD' AND END of lines table(only models,std done)
2348: l_mode := 'OPTIONS';
2349: COMPLETE_AND_CLASS_SAVE_MODE := TRUE;
2350: start from the first record again.
2351:

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

2481: OE_MSG_PUB.initialize;
2482: END IF;
2483:
2484: -- Looping through the table to first process all the models and
2485: -- standard lines in the table. When models and options are processed in
2486: -- one Process Order Call (like in Copy Order) options do not have
2487: -- top_model_line_id
2488: -- and link_to_line_id populated. Thus the Parent line has to be
2489: -- processed before the

Line 2497: l_mode := 'MODELS_AND_STANDARD' ;

2493: IF l_debug_level > 0 THEN
2494: oe_debug_pub.add( 'G_CONFIG_UI_USED '|| OE_CONFIG_UTIL.G_CONFIG_UI_USED , 5 ) ;
2495: END IF;
2496:
2497: l_mode := 'MODELS_AND_STANDARD' ;
2498:
2499: I := p_x_line_tbl.FIRST;
2500:
2501: WHILE I IS NOT NULL AND l_num_lines > 0

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

2850: END IF;
2851:
2852:
2853:
2854: IF (l_mode = 'MODELS_AND_STANDARD') AND
2855: l_check_item_type = 1 THEN
2856:
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'L_MODE IS MODELS_AND_STANDARD' , 1 ) ;

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

2854: IF (l_mode = 'MODELS_AND_STANDARD') AND
2855: l_check_item_type = 1 THEN
2856:
2857: IF l_debug_level > 0 THEN
2858: oe_debug_pub.add( 'L_MODE IS MODELS_AND_STANDARD' , 1 ) ;
2859: END IF;
2860:
2861: IF OE_Config_Util.G_Config_UI_Used = 'N' AND
2862: l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND

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

2948: END IF;
2949:
2950: l_process_this_line := TRUE;
2951:
2952: END IF; -- mode is standard.
2953:
2954:
2955: ---------------------- mode is options ----------------------
2956: IF (l_mode = 'OPTIONS') AND

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

3507:
3508: -- Get Who Information
3509:
3510: l_line_rec.last_update_date := SYSDATE;
3511: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3512: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3513: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3514: l_resp_id := FND_GLOBAL.RESP_ID;
3515: l_application_id := FND_GLOBAL.RESP_APPL_ID;

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

3509:
3510: l_line_rec.last_update_date := SYSDATE;
3511: l_line_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3512: l_line_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
3513: l_user_id := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3514: l_resp_id := FND_GLOBAL.RESP_ID;
3515: l_application_id := FND_GLOBAL.RESP_APPL_ID;
3516:
3517: IF l_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

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

3527:
3528: ELSIF l_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
3529:
3530: l_line_rec.creation_date := SYSDATE;
3531: l_line_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
3532:
3533: IF l_debug_level > 0 THEN
3534: oe_debug_pub.add( '3.STATUS '||L_LINE_REC.SCHEDULE_STATUS_CODE , 1 ) ;
3535: END IF;

Line 3688: IF (l_mode = 'MODELS_AND_STANDARD') AND (I IS NULL)

3684: END IF;
3685:
3686: I := p_x_line_tbl.NEXT(I);
3687:
3688: IF (l_mode = 'MODELS_AND_STANDARD') AND (I IS NULL)
3689: THEN
3690: I := p_x_line_tbl.FIRST;
3691: l_mode := 'OPTIONS';
3692: COMPLETE_AND_CLASS_SAVE_MODE := TRUE;

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

4286:
4287: -- Get Who Information
4288:
4289: l_Line_Scredit_rec.last_update_date := SYSDATE;
4290: l_Line_Scredit_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4291: l_Line_Scredit_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4292:
4293: IF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4294:

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

4296:
4297: ELSIF l_Line_Scredit_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4298:
4299: l_Line_Scredit_rec.creation_date := SYSDATE;
4300: l_Line_Scredit_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4301:
4302: OE_Line_Scredit_Util.Insert_Row (l_Line_Scredit_rec);
4303:
4304: END IF;

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

4942:
4943: -- Get Who Information
4944:
4945: l_Line_Payment_rec.last_update_date := SYSDATE;
4946: l_Line_Payment_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4947: l_Line_Payment_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
4948:
4949: IF l_Line_Payment_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
4950:

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

4958:
4959: ELSIF l_Line_Payment_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4960:
4961: l_Line_Payment_rec.creation_date := SYSDATE;
4962: l_Line_Payment_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
4963:
4964: IF l_debug_level > 0 THEN
4965: oe_debug_pub.add('Payment:before OE_Line_Payment_Util.Insert_Row', 5);
4966: END IF;

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

5307:
5308: -- Get Who Information
5309:
5310: l_Lot_Serial_rec.last_update_date := SYSDATE;
5311: l_Lot_Serial_rec.last_updated_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5312: l_Lot_Serial_rec.last_update_login := FND_GLOBAL.LOGIN_ID;
5313:
5314: IF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5315:

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

5317:
5318: ELSIF l_Lot_Serial_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5319:
5320: l_Lot_Serial_rec.creation_date := SYSDATE;
5321: l_Lot_Serial_rec.created_by := NVL(OE_STANDARD_WF.g_user_id, FND_GLOBAL.USER_ID); -- 3169637
5322:
5323: OE_Lot_Serial_Util.Insert_Row (l_Lot_Serial_rec);
5324:
5325: END IF;

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

8519:
8520: IF l_debug_level > 0 THEN
8521: oe_debug_pub.add( 'ENTERING OE_ORDER_PUB.PROCESS_ORDER' , 1 ) ;
8522: END IF;
8523: -- Standard call to check for call compatibility
8524:
8525: IF NOT FND_API.Compatible_API_Call
8526: ( l_api_version_number
8527: , p_api_version_number

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

10713:
10714: IF l_debug_level > 0 THEN
10715: oe_debug_pub.add( 'ENTERING OE_ORDER_PVT.LOCK_ORDER' , 1 ) ;
10716: END IF;
10717: -- Standard call to check for call compatibility
10718:
10719: IF NOT FND_API.Compatible_API_Call
10720: ( l_api_version_number
10721: , p_api_version_number

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

11300: I5 NUMBER; --Used as index.
11301: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11302: BEGIN
11303:
11304: -- Standard call to check for call compatibility
11305:
11306: IF NOT FND_API.Compatible_API_Call
11307: ( l_api_version_number
11308: , p_api_version_number

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

11638: l_api_name Varchar2(30) := 'CANCEL_ORDER';
11639: l_return_status Varchar2(1);
11640: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11641: Begin
11642: -- Standard call to check for call compatibility
11643:
11644: IF l_debug_level > 0 THEN
11645: oe_debug_pub.add( 'ENTERING OE_ORDER_PUB.CANCEL_ORDER' , 1 ) ;
11646: END IF;