DBA Data[Home] [Help]

APPS.AHL_MM_MTL_MGT_PVT dependencies on FND_REQUEST

Line 2313: fnd_request.set_org_id (l_destination_ou ) ;

2309: COMMIT;
2310:
2311:
2312: -- step 9 - Call the Requisition Import concurrent program to populate PO_REQUISTION_HEADERS_ALL and PO_REQUISITION_LINES_ALL table
2313: fnd_request.set_org_id (l_destination_ou ) ;
2314: L_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'REQIMPORT', null, null, false,'AHL', null, 'ALL', null ,'N', 'Y' , CHR(0),
2315: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2316: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2317: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,

Line 2314: L_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'REQIMPORT', null, null, false,'AHL', null, 'ALL', null ,'N', 'Y' , CHR(0),

2310:
2311:
2312: -- step 9 - Call the Requisition Import concurrent program to populate PO_REQUISTION_HEADERS_ALL and PO_REQUISITION_LINES_ALL table
2313: fnd_request.set_org_id (l_destination_ou ) ;
2314: L_REQUEST_ID := FND_REQUEST.SUBMIT_REQUEST ( 'PO', 'REQIMPORT', null, null, false,'AHL', null, 'ALL', null ,'N', 'Y' , CHR(0),
2315: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2316: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2317: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,
2318: null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null,

Line 2362: fnd_request.set_org_id ( l_destination_ou ) ;

2358: ', x_requisition_line_id = ' || X_REQUISITION_LINE_ID);
2359: END IF;
2360:
2361: -- step 10 - PO Create Internal Sales Order CP starts
2362: fnd_request.set_org_id ( l_destination_ou ) ;
2363: l_request_id := fnd_request.submit_request( 'PO', 'POCISO', NULL, NULL, FALSE );
2364: COMMIT;
2365: L_SUCCESS := FND_CONCURRENT.WAIT_FOR_REQUEST( REQUEST_ID => L_REQUEST_ID, INTERVAL => 3, PHASE => X_PHASE, STATUS => X_STATUS, DEV_PHASE => X_DEV_PHASE, DEV_STATUS => X_DEV_STATUS, MESSAGE => X_MESSAGE );
2366:

Line 2363: l_request_id := fnd_request.submit_request( 'PO', 'POCISO', NULL, NULL, FALSE );

2359: END IF;
2360:
2361: -- step 10 - PO Create Internal Sales Order CP starts
2362: fnd_request.set_org_id ( l_destination_ou ) ;
2363: l_request_id := fnd_request.submit_request( 'PO', 'POCISO', NULL, NULL, FALSE );
2364: COMMIT;
2365: L_SUCCESS := FND_CONCURRENT.WAIT_FOR_REQUEST( REQUEST_ID => L_REQUEST_ID, INTERVAL => 3, PHASE => X_PHASE, STATUS => X_STATUS, DEV_PHASE => X_DEV_PHASE, DEV_STATUS => X_DEV_STATUS, MESSAGE => X_MESSAGE );
2366:
2367: IF l_success <> TRUE THEN

Line 2377: FND_REQUEST.SET_ORG_ID ( L_DESTINATION_OU ) ;

2373: end if;
2374:
2375:
2376: -- step 11 - Order Entry Order Import CP starts
2377: FND_REQUEST.SET_ORG_ID ( L_DESTINATION_OU ) ;
2378: l_request_id := fnd_request.submit_request( 'ONT', 'OEOIMP', NULL, NULL, FALSE, l_destination_ou,10, x_requisition_hdr_id, NULL,'N',1,4,NULL,NULL,NULL,'Y','N','Y',fnd_global.org_id,'Y');
2379: COMMIT;
2380: -- wait for the ISO creation to complete.
2381: L_SUCCESS := FND_CONCURRENT.WAIT_FOR_REQUEST( REQUEST_ID => L_REQUEST_ID, INTERVAL => 3, PHASE => X_PHASE, STATUS => X_STATUS, DEV_PHASE => X_DEV_PHASE, DEV_STATUS => X_DEV_STATUS, MESSAGE => X_MESSAGE );

Line 2378: l_request_id := fnd_request.submit_request( 'ONT', 'OEOIMP', NULL, NULL, FALSE, l_destination_ou,10, x_requisition_hdr_id, NULL,'N',1,4,NULL,NULL,NULL,'Y','N','Y',fnd_global.org_id,'Y');

2374:
2375:
2376: -- step 11 - Order Entry Order Import CP starts
2377: FND_REQUEST.SET_ORG_ID ( L_DESTINATION_OU ) ;
2378: l_request_id := fnd_request.submit_request( 'ONT', 'OEOIMP', NULL, NULL, FALSE, l_destination_ou,10, x_requisition_hdr_id, NULL,'N',1,4,NULL,NULL,NULL,'Y','N','Y',fnd_global.org_id,'Y');
2379: COMMIT;
2380: -- wait for the ISO creation to complete.
2381: L_SUCCESS := FND_CONCURRENT.WAIT_FOR_REQUEST( REQUEST_ID => L_REQUEST_ID, INTERVAL => 3, PHASE => X_PHASE, STATUS => X_STATUS, DEV_PHASE => X_DEV_PHASE, DEV_STATUS => X_DEV_STATUS, MESSAGE => X_MESSAGE );
2382: