DBA Data[Home] [Help]

APPS.AMS_TCOP_PREVIEW dependencies on FND_GLOBAL

Line 143: FND_GLOBAL.USER_ID,

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,

Line 145: FND_GLOBAL.USER_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,
148: G_GLOBAL_NO_OF_PERIOD
149: );

Line 146: FND_GLOBAL.USER_ID,

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;

Line 1073: FND_GLOBAL.USER_ID,

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:

Line 1075: FND_GLOBAL.USER_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:
1078: );
1079: ELSE

Line 1076: FND_GLOBAL.USER_ID

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;

Line 2068: FND_GLOBAL.USER_ID,

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: );

Line 2070: FND_GLOBAL.USER_ID,

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

Line 2071: FND_GLOBAL.USER_ID

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:

Line 2138: FND_GLOBAL.USER_ID,

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: );

Line 2140: FND_GLOBAL.USER_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: );
2143: END IF;
2144:

Line 2141: FND_GLOBAL.USER_ID

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

Line 2169: FND_GLOBAL.USER_ID,

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: );

Line 2171: FND_GLOBAL.USER_ID,

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;

Line 2172: FND_GLOBAL.USER_ID

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:

Line 2366: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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;

Line 2416: LAST_UPDATED_BY = FND_GLOBAL.USER_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);

Line 2436: LAST_UPDATED_BY = FND_GLOBAL.USER_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:

Line 2490: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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:

Line 2507: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

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: