APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_PRVW_FATIGUE

Line 1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S

1314: AND PREVIEW_ID = G_PRVW_REQUEST_ID
1315: AND rownum = p_row_num
1316: ORDER BY CONTACT.CONTACT_DATE;
1317:
1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S
1319: CURSOR C_GET_NEXT_FATIGUE
1320: IS
1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
1322: FROM DUAL;

Line 1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL

1317:
1318: -- Get Nextval from AMS_TCOP_PRVW_FATIGUE_S
1319: CURSOR C_GET_NEXT_FATIGUE
1320: IS
1321: SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
1322: FROM DUAL;
1323:
1324: CURSOR C_GET_NEXT_FTG_DTL
1325: IS

Line 2041: -- Get the next val from AMS_TCOP_PRVW_FATIGUE_S

2037: END IF;
2038:
2039: END LOOP;
2040:
2041: -- Get the next val from AMS_TCOP_PRVW_FATIGUE_S
2042: OPEN C_GET_NEXT_FATIGUE;
2043: FETCH C_GET_NEXT_FATIGUE
2044: INTO l_preview_id;
2045: CLOSE C_GET_NEXT_FATIGUE;

Line 2049: INSERT INTO AMS_TCOP_PRVW_FATIGUE

2045: CLOSE C_GET_NEXT_FATIGUE;
2046:
2047: l_fatigue_count := G_FATIGUE_PARTY_LIST.COUNT;
2048: -- Bulk Insert the relevant Tables
2049: INSERT INTO AMS_TCOP_PRVW_FATIGUE
2050: (
2051: PREVIEW_ID,
2052: REQUEST_ID,
2053: PREVIEW_DATE,

Line 2372: DELETE FROM AMS_TCOP_PRVW_FATIGUE

2368:
2369: DELETE FROM AMS_TCOP_PRVW_CONTACTS
2370: WHERE PREVIEW_ID = G_PRVW_REQUEST_ID;
2371:
2372: DELETE FROM AMS_TCOP_PRVW_FATIGUE
2373: WHERE
2374: REQUEST_ID IN
2375: (
2376: SELECT REQUEST_ID FROM AMS_TCOP_PRVW_REQUESTS