139: 'NEW',
140: p_list_header_id,
141: p_total_preview_size,
142: sysdate,
143: FND_GLOBAL.USER_ID,
144: sysdate,
145: FND_GLOBAL.USER_ID,
146: FND_GLOBAL.USER_ID,
147: 1,
141: p_total_preview_size,
142: sysdate,
143: FND_GLOBAL.USER_ID,
144: sysdate,
145: FND_GLOBAL.USER_ID,
146: FND_GLOBAL.USER_ID,
147: 1,
148: G_GLOBAL_NO_OF_PERIOD
149: );
142: sysdate,
143: FND_GLOBAL.USER_ID,
144: sysdate,
145: FND_GLOBAL.USER_ID,
146: FND_GLOBAL.USER_ID,
147: 1,
148: G_GLOBAL_NO_OF_PERIOD
149: );
150: commit;
1069: l_contact_party_list(i),
1070: G_PRVW_REQUEST_ID,
1071: l_contact_date,
1072: sysdate,
1073: FND_GLOBAL.USER_ID,
1074: sysdate,
1075: FND_GLOBAL.USER_ID,
1076: FND_GLOBAL.USER_ID
1077:
1071: l_contact_date,
1072: sysdate,
1073: FND_GLOBAL.USER_ID,
1074: sysdate,
1075: FND_GLOBAL.USER_ID,
1076: FND_GLOBAL.USER_ID
1077:
1078: );
1079: ELSE
1072: sysdate,
1073: FND_GLOBAL.USER_ID,
1074: sysdate,
1075: FND_GLOBAL.USER_ID,
1076: FND_GLOBAL.USER_ID
1077:
1078: );
1079: ELSE
1080: G_NO_SCHEDULE_PIPELINE := TRUE;
2064: G_PRVW_REQUEST_ID,
2065: p_preview_date,
2066: l_fatigue_count,
2067: sysdate,
2068: FND_GLOBAL.USER_ID,
2069: sysdate,
2070: FND_GLOBAL.USER_ID,
2071: FND_GLOBAL.USER_ID
2072: );
2066: l_fatigue_count,
2067: sysdate,
2068: FND_GLOBAL.USER_ID,
2069: sysdate,
2070: FND_GLOBAL.USER_ID,
2071: FND_GLOBAL.USER_ID
2072: );
2073:
2074: IF (G_FATIGUE_BY_PARTY_LIST.count > 0) THEN
2067: sysdate,
2068: FND_GLOBAL.USER_ID,
2069: sysdate,
2070: FND_GLOBAL.USER_ID,
2071: FND_GLOBAL.USER_ID
2072: );
2073:
2074: IF (G_FATIGUE_BY_PARTY_LIST.count > 0) THEN
2075:
2134: l_fatigue_detail_list(i),
2135: l_preview_id,
2136: G_FATIGUE_PARTY_LIST(i),
2137: sysdate,
2138: FND_GLOBAL.USER_ID,
2139: sysdate,
2140: FND_GLOBAL.USER_ID,
2141: FND_GLOBAL.USER_ID
2142: );
2136: G_FATIGUE_PARTY_LIST(i),
2137: sysdate,
2138: FND_GLOBAL.USER_ID,
2139: sysdate,
2140: FND_GLOBAL.USER_ID,
2141: FND_GLOBAL.USER_ID
2142: );
2143: END IF;
2144:
2137: sysdate,
2138: FND_GLOBAL.USER_ID,
2139: sysdate,
2140: FND_GLOBAL.USER_ID,
2141: FND_GLOBAL.USER_ID
2142: );
2143: END IF;
2144:
2145: IF (G_FATIGUE_BY_SCHEDULE_LIST.count > 0 ) THEN
2165: l_fatigue_by_id_list(i),
2166: l_fatigue_detail_id_list(i),
2167: G_FATIGUE_BY_SCHEDULE_LIST(i),
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: sysdate,
2171: FND_GLOBAL.USER_ID,
2172: FND_GLOBAL.USER_ID
2173: );
2167: G_FATIGUE_BY_SCHEDULE_LIST(i),
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: sysdate,
2171: FND_GLOBAL.USER_ID,
2172: FND_GLOBAL.USER_ID
2173: );
2174:
2175: END IF;
2168: sysdate,
2169: FND_GLOBAL.USER_ID,
2170: sysdate,
2171: FND_GLOBAL.USER_ID,
2172: FND_GLOBAL.USER_ID
2173: );
2174:
2175: END IF;
2176:
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;
2368:
2369: DELETE FROM AMS_TCOP_PRVW_CONTACTS
2370: WHERE PREVIEW_ID = G_PRVW_REQUEST_ID;
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;
2418:
2419:
2420: PREVIEW_FATIGUE(l_list_header_id);
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;
2438:
2439: RETURN 'ERROR';
2440:
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;
2492: PREVIEW_FATIGUE(l_list_header_id);
2493: return 'SUCCESS';
2494:
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;
2509:
2510: RETURN 'ERROR';
2511: