APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_PRVW_REQUESTS

Line 97: SELECT ams_tcop_prvw_requests_s.nextval

93: IS
94: -- Cursor to get the next sequence number
95: CURSOR C_GET_PRVW_RQST_ID
96: IS
97: SELECT ams_tcop_prvw_requests_s.nextval
98: FROM DUAL;
99:
100:
101: -- Use Autonomous Transaction to commit the data

Line 115: -- Create a row in AMS_TCOP_PRVW_REQUESTS

111: IF (G_GLOBAL_NO_OF_PERIOD IS NULL ) THEN
112: G_GLOBAL_NO_OF_PERIOD := 7;
113: END IF;
114:
115: -- Create a row in AMS_TCOP_PRVW_REQUESTS
116:
117:
118:
119: INSERT INTO

Line 120: AMS_TCOP_PRVW_REQUESTS

116:
117:
118:
119: INSERT INTO
120: AMS_TCOP_PRVW_REQUESTS
121: (
122: REQUEST_ID,
123: GENERATION_DATE,
124: STATUS,

Line 2363: UPDATE AMS_TCOP_PRVW_REQUESTS

2359:
2360:
2361:
2362: -- Finally Update the Status to COMPLETE
2363: UPDATE AMS_TCOP_PRVW_REQUESTS
2364: SET STATUS='COMPLETE',
2365: LAST_UPDATE_DATE = sysdate,
2366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2367: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line 2376: SELECT REQUEST_ID FROM AMS_TCOP_PRVW_REQUESTS

2372: DELETE FROM AMS_TCOP_PRVW_FATIGUE
2373: WHERE
2374: REQUEST_ID IN
2375: (
2376: SELECT REQUEST_ID FROM AMS_TCOP_PRVW_REQUESTS
2377: WHERE LIST_HEADER_ID = p_list_header_id
2378: AND REQUEST_ID <> G_PRVW_REQUEST_ID
2379: );
2380:

Line 2382: DELETE FROM AMS_TCOP_PRVW_REQUESTS

2378: AND REQUEST_ID <> G_PRVW_REQUEST_ID
2379: );
2380:
2381:
2382: DELETE FROM AMS_TCOP_PRVW_REQUESTS
2383: WHERE LIST_HEADER_ID = p_list_header_id
2384: AND REQUEST_ID <> G_PRVW_REQUEST_ID;
2385:
2386: END PREVIEW_FATIGUE;

Line 2413: UPDATE AMS_TCOP_PRVW_REQUESTS

2409:
2410: G_GLOBAL_NO_OF_PERIOD := p_event.getValueForParameter('GLOBAL_NO_OF_PERIOD');
2411:
2412: -- First Update the Status to ACTIVE
2413: UPDATE AMS_TCOP_PRVW_REQUESTS
2414: SET STATUS='ACTIVE',
2415: LAST_UPDATE_DATE = sysdate,
2416: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2417: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line 2433: UPDATE AMS_TCOP_PRVW_REQUESTS

2429: p_event.getEventName( ), p_subscription_guid);
2430: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2431:
2432: -- First Update the Status to ERROR
2433: UPDATE AMS_TCOP_PRVW_REQUESTS
2434: SET STATUS='ERROR',
2435: LAST_UPDATE_DATE = sysdate,
2436: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2437: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line 2487: UPDATE AMS_TCOP_PRVW_REQUESTS

2483: -- First Update the Status to ACTIVE
2484:
2485:
2486:
2487: UPDATE AMS_TCOP_PRVW_REQUESTS
2488: SET STATUS='ACTIVE',
2489: LAST_UPDATE_DATE = sysdate,
2490: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2491: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line 2504: UPDATE AMS_TCOP_PRVW_REQUESTS

2500: p_event.getEventName( ), p_subscription_guid);
2501: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2502:
2503: -- First Update the Status to ERROR
2504: UPDATE AMS_TCOP_PRVW_REQUESTS
2505: SET STATUS='ERROR',
2506: LAST_UPDATE_DATE = sysdate,
2507: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
2508: WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line 2533: FROM AMS_TCOP_PRVW_REQUESTS

2529:
2530: CURSOR C_LIST_PRVW_REQUEST_STATUS
2531: IS
2532: SELECT REQUEST_ID, STATUS
2533: FROM AMS_TCOP_PRVW_REQUESTS
2534: WHERE LIST_HEADER_ID = p_list_header_id
2535: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);
2536:
2537: CURSOR C_PREVIEW_SIZE

Line 2535: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);

2531: IS
2532: SELECT REQUEST_ID, STATUS
2533: FROM AMS_TCOP_PRVW_REQUESTS
2534: WHERE LIST_HEADER_ID = p_list_header_id
2535: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);
2536:
2537: CURSOR C_PREVIEW_SIZE
2538: IS
2539: SELECT COUNT(PARTY_ID)

Line 2643: FROM AMS_TCOP_PRVW_REQUESTS

2639:
2640: CURSOR C_LIST_PRVW_REQUEST_STATUS
2641: IS
2642: SELECT REQUEST_ID, STATUS
2643: FROM AMS_TCOP_PRVW_REQUESTS
2644: WHERE LIST_HEADER_ID = p_list_header_id
2645: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);
2646:
2647: CURSOR C_PREVIEW_SIZE

Line 2645: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);

2641: IS
2642: SELECT REQUEST_ID, STATUS
2643: FROM AMS_TCOP_PRVW_REQUESTS
2644: WHERE LIST_HEADER_ID = p_list_header_id
2645: and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);
2646:
2647: CURSOR C_PREVIEW_SIZE
2648: IS
2649: SELECT COUNT(PARTY_ID)