eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_ORG_INFO_PUB dependencies on HZ_UTILITY_PUB

Line 111: X_CREATED_BY => hz_utility_pub.CREATED_BY,

107: X_STOCK_EXCHANGE_ID => p_stock_markets_rec.stock_exchange_id,
108: X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
109: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
110: X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
111: X_CREATED_BY => hz_utility_pub.CREATED_BY,
112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

108: X_COUNTRY_OF_RESIDENCE => p_stock_markets_rec.COUNTRY_OF_RESIDENCE,
109: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
110: X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
111: X_CREATED_BY => hz_utility_pub.CREATED_BY,
112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

109: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
110: X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
111: X_CREATED_BY => hz_utility_pub.CREATED_BY,
112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

110: X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
111: X_CREATED_BY => hz_utility_pub.CREATED_BY,
112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

111: X_CREATED_BY => hz_utility_pub.CREATED_BY,
112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

112: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
120: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE

Line 117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

113: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
120: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
121: );

Line 118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

114: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
120: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
121: );
122:

Line 119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

115: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
116: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
117: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
118: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
119: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
120: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
121: );
122:
123: END do_create_stock_markets;

Line 208: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

204: RAISE FND_API.G_EXC_ERROR;
205: END IF;
206:
207: -- pass back last update date
208: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
209:
210: -- Bug 1428526: Should pass updated stock market info. to caller.
211: -- Make sure to use values in p_stock_markets_rec.* when calling update table
212: -- handler. Need to update p_stock_markets_rec first.

Line 224: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

220: X_STOCK_EXCHANGE_CODE => p_stock_markets_rec.STOCK_EXCHANGE_CODE,
221: X_STOCK_EXCHANGE_NAME => p_stock_markets_rec.STOCK_EXCHANGE_NAME,
222: X_CREATED_BY => FND_API.G_MISS_NUM,
223: X_CREATION_DATE => FND_API.G_MISS_DATE,
224: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
225: X_LAST_UPDATE_DATE => p_last_update_date,
226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

222: X_CREATED_BY => FND_API.G_MISS_NUM,
223: X_CREATION_DATE => FND_API.G_MISS_DATE,
224: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
225: X_LAST_UPDATE_DATE => p_last_update_date,
226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

223: X_CREATION_DATE => FND_API.G_MISS_DATE,
224: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
225: X_LAST_UPDATE_DATE => p_last_update_date,
226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
231: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE

Line 228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

224: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
225: X_LAST_UPDATE_DATE => p_last_update_date,
226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
231: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
232: );

Line 229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

225: X_LAST_UPDATE_DATE => p_last_update_date,
226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
231: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
232: );
233:

Line 230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

226: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
227: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
228: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
229: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
230: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
231: X_WH_UPDATE_DATE => p_stock_markets_rec.WH_UPDATE_DATE
232: );
233:
234: END do_update_stock_markets;

Line 333: X_CREATED_BY => hz_utility_pub.CREATED_BY,

329: X_STOCK_TICKER_SYMBOL => p_security_issued_rec.STOCK_TICKER_SYMBOL,
330: X_SECURITY_CURRENCY_CODE => p_security_issued_rec.SECURITY_CURRENCY_CODE,
331: X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
332: X_END_DATE => p_security_issued_rec.END_DATE,
333: X_CREATED_BY => hz_utility_pub.CREATED_BY,
334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

330: X_SECURITY_CURRENCY_CODE => p_security_issued_rec.SECURITY_CURRENCY_CODE,
331: X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
332: X_END_DATE => p_security_issued_rec.END_DATE,
333: X_CREATED_BY => hz_utility_pub.CREATED_BY,
334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

331: X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
332: X_END_DATE => p_security_issued_rec.END_DATE,
333: X_CREATED_BY => hz_utility_pub.CREATED_BY,
334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

332: X_END_DATE => p_security_issued_rec.END_DATE,
333: X_CREATED_BY => hz_utility_pub.CREATED_BY,
334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

333: X_CREATED_BY => hz_utility_pub.CREATED_BY,
334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

334: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
342: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,

Line 339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

335: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
342: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
343: X_STATUS =>p_security_issued_rec.STATUS

Line 340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

336: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
342: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
343: X_STATUS =>p_security_issued_rec.STATUS
344: );

Line 341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

337: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
338: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
339: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
340: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
341: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
342: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
343: X_STATUS =>p_security_issued_rec.STATUS
344: );
345:

Line 433: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: -- pass back last_update_date
433: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
434:
435: -- Bug 1428526: Should pass updated security issued info. to caller.
436: -- Make sure to use values in p_security_issued_rec.* when calling update table
437: -- handler. Need to update p_security_issued_rec first.

Line 456: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

452: X_BEGIN_DATE => p_security_issued_rec.BEGIN_DATE,
453: X_END_DATE => p_security_issued_rec.END_DATE,
454: X_CREATED_BY => FND_API.G_MISS_NUM,
455: X_CREATION_DATE => FND_API.G_MISS_DATE,
456: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
457: X_LAST_UPDATE_DATE => p_last_update_date,
458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

454: X_CREATED_BY => FND_API.G_MISS_NUM,
455: X_CREATION_DATE => FND_API.G_MISS_DATE,
456: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
457: X_LAST_UPDATE_DATE => p_last_update_date,
458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

455: X_CREATION_DATE => FND_API.G_MISS_DATE,
456: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
457: X_LAST_UPDATE_DATE => p_last_update_date,
458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
463: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,

Line 460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

456: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
457: X_LAST_UPDATE_DATE => p_last_update_date,
458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
463: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
464: X_STATUS => p_security_issued_rec.STATUS

Line 461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

457: X_LAST_UPDATE_DATE => p_last_update_date,
458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
463: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
464: X_STATUS => p_security_issued_rec.STATUS
465: );

Line 462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

458: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
459: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
460: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
461: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
462: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
463: X_WH_UPDATE_DATE => p_security_issued_rec.WH_UPDATE_DATE,
464: X_STATUS => p_security_issued_rec.STATUS
465: );
466:

Line 597: x_created_by => hz_utility_pub.created_by,

593: x_document_reference => p_financial_reports_rec.document_reference,
594: x_issued_period => p_financial_reports_rec.issued_period,
595: x_requiring_authority => p_financial_reports_rec.requiring_authority,
596: x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
597: x_created_by => hz_utility_pub.created_by,
598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,

Line 598: x_creation_date => hz_utility_pub.creation_date,

594: x_issued_period => p_financial_reports_rec.issued_period,
595: x_requiring_authority => p_financial_reports_rec.requiring_authority,
596: x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
597: x_created_by => hz_utility_pub.created_by,
598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,

Line 599: x_last_update_login => hz_utility_pub.last_update_login,

595: x_requiring_authority => p_financial_reports_rec.requiring_authority,
596: x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
597: x_created_by => hz_utility_pub.created_by,
598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,

Line 600: x_last_update_date => hz_utility_pub.last_update_date,

596: x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
597: x_created_by => hz_utility_pub.created_by,
598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,

Line 601: x_last_updated_by => hz_utility_pub.last_updated_by,

597: x_created_by => hz_utility_pub.created_by,
598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,
605: x_program_update_date => hz_utility_pub.program_update_date,

Line 602: x_request_id => hz_utility_pub.request_id,

598: x_creation_date => hz_utility_pub.creation_date,
599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,
605: x_program_update_date => hz_utility_pub.program_update_date,
606: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,

Line 603: x_program_application_id => hz_utility_pub.program_application_id,

599: x_last_update_login => hz_utility_pub.last_update_login,
600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,
605: x_program_update_date => hz_utility_pub.program_update_date,
606: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
607: x_report_start_date => p_financial_reports_rec.report_start_date,

Line 604: x_program_id => hz_utility_pub.program_id,

600: x_last_update_date => hz_utility_pub.last_update_date,
601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,
605: x_program_update_date => hz_utility_pub.program_update_date,
606: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
607: x_report_start_date => p_financial_reports_rec.report_start_date,
608: x_report_end_date => p_financial_reports_rec.report_end_date,

Line 605: x_program_update_date => hz_utility_pub.program_update_date,

601: x_last_updated_by => hz_utility_pub.last_updated_by,
602: x_request_id => hz_utility_pub.request_id,
603: x_program_application_id => hz_utility_pub.program_application_id,
604: x_program_id => hz_utility_pub.program_id,
605: x_program_update_date => hz_utility_pub.program_update_date,
606: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
607: x_report_start_date => p_financial_reports_rec.report_start_date,
608: x_report_end_date => p_financial_reports_rec.report_end_date,
609: x_audit_ind => p_financial_reports_rec.audit_ind,

Line 773: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771:
772: -- pass back last update date
773: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
774:
775: -- Bug 1428526: Should pass updated financial reports info. to caller.
776: -- Make sure to use values in p_financial_reports_rec.* when calling update table
777: -- handler. Need to update p_financial_reports_rec first.

Line 792: x_last_update_login => hz_utility_pub.last_update_login,

788: x_requiring_authority => p_financial_reports_rec.requiring_authority,
789: x_type_of_financial_report => p_financial_reports_rec.type_of_financial_report,
790: x_created_by => fnd_api.g_miss_num,
791: x_creation_date => fnd_api.g_miss_date,
792: x_last_update_login => hz_utility_pub.last_update_login,
793: x_last_update_date => p_last_update_date,
794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,

Line 794: x_last_updated_by => hz_utility_pub.last_updated_by,

790: x_created_by => fnd_api.g_miss_num,
791: x_creation_date => fnd_api.g_miss_date,
792: x_last_update_login => hz_utility_pub.last_update_login,
793: x_last_update_date => p_last_update_date,
794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,
797: x_program_id => hz_utility_pub.program_id,
798: x_program_update_date => hz_utility_pub.program_update_date,

Line 795: x_request_id => hz_utility_pub.request_id,

791: x_creation_date => fnd_api.g_miss_date,
792: x_last_update_login => hz_utility_pub.last_update_login,
793: x_last_update_date => p_last_update_date,
794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,
797: x_program_id => hz_utility_pub.program_id,
798: x_program_update_date => hz_utility_pub.program_update_date,
799: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,

Line 796: x_program_application_id => hz_utility_pub.program_application_id,

792: x_last_update_login => hz_utility_pub.last_update_login,
793: x_last_update_date => p_last_update_date,
794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,
797: x_program_id => hz_utility_pub.program_id,
798: x_program_update_date => hz_utility_pub.program_update_date,
799: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
800: x_report_start_date => p_financial_reports_rec.report_start_date,

Line 797: x_program_id => hz_utility_pub.program_id,

793: x_last_update_date => p_last_update_date,
794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,
797: x_program_id => hz_utility_pub.program_id,
798: x_program_update_date => hz_utility_pub.program_update_date,
799: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
800: x_report_start_date => p_financial_reports_rec.report_start_date,
801: x_report_end_date => p_financial_reports_rec.report_end_date,

Line 798: x_program_update_date => hz_utility_pub.program_update_date,

794: x_last_updated_by => hz_utility_pub.last_updated_by,
795: x_request_id => hz_utility_pub.request_id,
796: x_program_application_id => hz_utility_pub.program_application_id,
797: x_program_id => hz_utility_pub.program_id,
798: x_program_update_date => hz_utility_pub.program_update_date,
799: x_wh_udpate_id => p_financial_reports_rec.wh_udpate_id,
800: x_report_start_date => p_financial_reports_rec.report_start_date,
801: x_report_end_date => p_financial_reports_rec.report_end_date,
802: x_audit_ind => p_financial_reports_rec.audit_ind,

Line 1013: x_created_by => hz_utility_pub.created_by,

1009: x_financial_number_name => p_financial_numbers_rec.financial_number_name,
1010: x_financial_units_applied => p_financial_numbers_rec.financial_units_applied,
1011: x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
1012: x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
1013: x_created_by => hz_utility_pub.created_by,
1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,

Line 1014: x_creation_date => hz_utility_pub.creation_date,

1010: x_financial_units_applied => p_financial_numbers_rec.financial_units_applied,
1011: x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
1012: x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
1013: x_created_by => hz_utility_pub.created_by,
1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,

Line 1015: x_last_update_login => hz_utility_pub.last_update_login,

1011: x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
1012: x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
1013: x_created_by => hz_utility_pub.created_by,
1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,

Line 1016: x_last_update_date => hz_utility_pub.last_update_date,

1012: x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
1013: x_created_by => hz_utility_pub.created_by,
1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,

Line 1017: x_last_updated_by => hz_utility_pub.last_updated_by,

1013: x_created_by => hz_utility_pub.created_by,
1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,
1021: x_program_update_date => hz_utility_pub.program_update_date,

Line 1018: x_request_id => hz_utility_pub.request_id,

1014: x_creation_date => hz_utility_pub.creation_date,
1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,
1021: x_program_update_date => hz_utility_pub.program_update_date,
1022: x_wh_update_date => p_financial_numbers_rec.wh_update_date,

Line 1019: x_program_application_id => hz_utility_pub.program_application_id,

1015: x_last_update_login => hz_utility_pub.last_update_login,
1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,
1021: x_program_update_date => hz_utility_pub.program_update_date,
1022: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1023: x_content_source_type => l_rep_content_source_type,

Line 1020: x_program_id => hz_utility_pub.program_id,

1016: x_last_update_date => hz_utility_pub.last_update_date,
1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,
1021: x_program_update_date => hz_utility_pub.program_update_date,
1022: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1023: x_content_source_type => l_rep_content_source_type,
1024: x_status => p_financial_numbers_rec.status,

Line 1021: x_program_update_date => hz_utility_pub.program_update_date,

1017: x_last_updated_by => hz_utility_pub.last_updated_by,
1018: x_request_id => hz_utility_pub.request_id,
1019: x_program_application_id => hz_utility_pub.program_application_id,
1020: x_program_id => hz_utility_pub.program_id,
1021: x_program_update_date => hz_utility_pub.program_update_date,
1022: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1023: x_content_source_type => l_rep_content_source_type,
1024: x_status => p_financial_numbers_rec.status,
1025: x_actual_content_source => l_rep_actual_content_source

Line 1209: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

1205: RAISE FND_API.G_EXC_ERROR;
1206: END IF;
1207:
1208: -- pass back the last update_date
1209: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
1210:
1211: -- Bug 1428526: Should pass updated financial numbers info. to caller.
1212: -- Make sure to use values in p_financial_numbers_rec.* when calling update table
1213: -- handler. Need to update p_financial_numbers_rec first.

Line 1228: x_last_update_login => hz_utility_pub.last_update_login,

1224: x_financial_number_currency => p_financial_numbers_rec.financial_number_currency,
1225: x_projected_actual_flag => p_financial_numbers_rec.projected_actual_flag,
1226: x_created_by => fnd_api.g_miss_num,
1227: x_creation_date => fnd_api.g_miss_date,
1228: x_last_update_login => hz_utility_pub.last_update_login,
1229: x_last_update_date => p_last_update_date,
1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,

Line 1230: x_last_updated_by => hz_utility_pub.last_updated_by,

1226: x_created_by => fnd_api.g_miss_num,
1227: x_creation_date => fnd_api.g_miss_date,
1228: x_last_update_login => hz_utility_pub.last_update_login,
1229: x_last_update_date => p_last_update_date,
1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,
1233: x_program_id => hz_utility_pub.program_id,
1234: x_program_update_date => hz_utility_pub.program_update_date,

Line 1231: x_request_id => hz_utility_pub.request_id,

1227: x_creation_date => fnd_api.g_miss_date,
1228: x_last_update_login => hz_utility_pub.last_update_login,
1229: x_last_update_date => p_last_update_date,
1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,
1233: x_program_id => hz_utility_pub.program_id,
1234: x_program_update_date => hz_utility_pub.program_update_date,
1235: x_wh_update_date => p_financial_numbers_rec.wh_update_date,

Line 1232: x_program_application_id => hz_utility_pub.program_application_id,

1228: x_last_update_login => hz_utility_pub.last_update_login,
1229: x_last_update_date => p_last_update_date,
1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,
1233: x_program_id => hz_utility_pub.program_id,
1234: x_program_update_date => hz_utility_pub.program_update_date,
1235: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1236: -- bug 2197181 : content_source_type is obsolete and it is non-updateable.

Line 1233: x_program_id => hz_utility_pub.program_id,

1229: x_last_update_date => p_last_update_date,
1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,
1233: x_program_id => hz_utility_pub.program_id,
1234: x_program_update_date => hz_utility_pub.program_update_date,
1235: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1236: -- bug 2197181 : content_source_type is obsolete and it is non-updateable.
1237: x_content_source_type => fnd_api.g_miss_char,

Line 1234: x_program_update_date => hz_utility_pub.program_update_date,

1230: x_last_updated_by => hz_utility_pub.last_updated_by,
1231: x_request_id => hz_utility_pub.request_id,
1232: x_program_application_id => hz_utility_pub.program_application_id,
1233: x_program_id => hz_utility_pub.program_id,
1234: x_program_update_date => hz_utility_pub.program_update_date,
1235: x_wh_update_date => p_financial_numbers_rec.wh_update_date,
1236: -- bug 2197181 : content_source_type is obsolete and it is non-updateable.
1237: x_content_source_type => fnd_api.g_miss_char,
1238: x_status => p_financial_numbers_rec.status,

Line 1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,

1361: X_EXPIRES_ON_DATE => p_certifications_rec.EXPIRES_ON_DATE,
1362: X_GRADE => p_certifications_rec.GRADE,
1363: X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
1364: X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

1362: X_GRADE => p_certifications_rec.GRADE,
1363: X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
1364: X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1363: X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
1364: X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

1364: X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1365: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1366: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1374: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,

Line 1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1367: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1374: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1375: X_STATUS => p_certifications_rec.STATUS

Line 1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1368: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1374: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1375: X_STATUS => p_certifications_rec.STATUS
1376: );

Line 1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1369: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1370: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1371: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1372: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1373: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1374: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1375: X_STATUS => p_certifications_rec.STATUS
1376: );
1377:

Line 1463: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

1459: RAISE FND_API.G_EXC_ERROR;
1460: END IF;
1461:
1462: -- pass back the last update date
1463: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
1464:
1465: -- Bug 1428526: Should pass updated certifications info. to caller.
1466: -- Make sure to use values in p_certifications_rec.* when calling update table
1467: -- handler. Need to update p_certifications_rec first.

Line 1483: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1479: X_ISSUED_BY_AUTHORITY => p_certifications_rec.ISSUED_BY_AUTHORITY,
1480: X_ISSUED_ON_DATE => p_certifications_rec.ISSUED_ON_DATE,
1481: X_CREATED_BY => FND_API.G_MISS_NUM,
1482: X_CREATION_DATE => FND_API.G_MISS_DATE,
1483: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1484: X_LAST_UPDATE_DATE => p_last_update_date,
1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1481: X_CREATED_BY => FND_API.G_MISS_NUM,
1482: X_CREATION_DATE => FND_API.G_MISS_DATE,
1483: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1484: X_LAST_UPDATE_DATE => p_last_update_date,
1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1482: X_CREATION_DATE => FND_API.G_MISS_DATE,
1483: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1484: X_LAST_UPDATE_DATE => p_last_update_date,
1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1490: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,

Line 1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1483: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1484: X_LAST_UPDATE_DATE => p_last_update_date,
1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1490: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1491: X_STATUS => p_certifications_rec.STATUS

Line 1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1484: X_LAST_UPDATE_DATE => p_last_update_date,
1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1490: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1491: X_STATUS => p_certifications_rec.STATUS
1492: );

Line 1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1485: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1486: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1487: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1488: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1489: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1490: X_WH_UPDATE_DATE => p_certifications_rec.WH_UPDATE_DATE,
1491: X_STATUS => p_certifications_rec.STATUS
1492: );
1493:

Line 1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,

1585: X_INDUSTRY_REFERENCE => p_industrial_reference_rec.INDUSTRY_REFERENCE,
1586: X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,
1587: X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
1588: X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

1586: X_ISSUED_BY_AUTHORITY => p_industrial_reference_rec.ISSUED_BY_AUTHORITY,
1587: X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
1588: X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1587: X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
1588: X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

1588: X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1589: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1590: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1598: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,

Line 1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1591: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1598: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1599: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,

Line 1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1592: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1598: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1599: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
1600: X_STATUS =>p_industrial_reference_rec.STATUS

Line 1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1593: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1594: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1595: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1596: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1597: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1598: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1599: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
1600: X_STATUS =>p_industrial_reference_rec.STATUS
1601: );

Line 1688: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

1684: RAISE FND_API.G_EXC_ERROR;
1685: END IF;
1686:
1687: -- pass back the last update date
1688: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
1689:
1690: -- Bug 1428526: Should pass updated industrial reference info. to caller.
1691: -- Make sure to use values in p_industrial_reference_rec.* when calling update table
1692: -- handler. Need to update p_industrial_reference_rec first.

Line 1705: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1701: X_NAME_OF_REFERENCE => p_industrial_reference_rec.NAME_OF_REFERENCE,
1702: X_RECOGNIZED_AS_OF_DATE => p_industrial_reference_rec.RECOGNIZED_AS_OF_DATE,
1703: X_CREATED_BY => FND_API.G_MISS_NUM,
1704: X_CREATION_DATE => FND_API.G_MISS_DATE,
1705: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1706: X_LAST_UPDATE_DATE => p_last_update_date,
1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1703: X_CREATED_BY => FND_API.G_MISS_NUM,
1704: X_CREATION_DATE => FND_API.G_MISS_DATE,
1705: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1706: X_LAST_UPDATE_DATE => p_last_update_date,
1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1704: X_CREATION_DATE => FND_API.G_MISS_DATE,
1705: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1706: X_LAST_UPDATE_DATE => p_last_update_date,
1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1712: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,

Line 1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1705: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1706: X_LAST_UPDATE_DATE => p_last_update_date,
1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1712: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1713: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,

Line 1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1706: X_LAST_UPDATE_DATE => p_last_update_date,
1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1712: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1713: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
1714: X_STATUS =>p_industrial_reference_rec.STATUS

Line 1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1707: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1708: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1709: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1710: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1711: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1712: X_WH_UPDATE_DATE => p_industrial_reference_rec.WH_UPDATE_DATE,
1713: X_PARTY_ID => p_industrial_reference_rec.PARTY_ID,
1714: X_STATUS =>p_industrial_reference_rec.STATUS
1715: );

Line 1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,

1808: X_INDUSTRIAL_CODE_NAME => p_industrial_classes_rec.INDUSTRIAL_CODE_NAME,
1809: X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,
1810: X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
1811: X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

1809: X_CODE_PRIMARY_SEGMENT => p_industrial_classes_rec.CODE_PRIMARY_SEGMENT,
1810: X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
1811: X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1810: X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
1811: X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

1811: X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1812: X_CREATED_BY => hz_utility_pub.CREATED_BY,
1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1813: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1821: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE

Line 1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1814: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1821: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1822: );

Line 1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1815: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1821: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1822: );
1823:

Line 1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1816: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1817: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1818: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1819: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1820: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1821: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1822: );
1823:
1824: END do_create_industrial_classes;

Line 1910: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

1906: RAISE FND_API.G_EXC_ERROR;
1907: END IF;
1908:
1909: -- pass back the last update date
1910: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
1911:
1912: -- Bug 1428526: Should pass updated industrial classes info. to caller.
1913: -- Make sure to use values in p_industrial_classes_rec.* when calling update table
1914: -- handler. Need to update p_industrial_classes_rec first.

Line 1927: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

1923: X_INDUSTRIAL_CLASS_SOURCE => p_industrial_classes_rec.INDUSTRIAL_CLASS_SOURCE,
1924: X_CODE_DESCRIPTION => p_industrial_classes_rec.CODE_DESCRIPTION,
1925: X_CREATED_BY => FND_API.G_MISS_NUM,
1926: X_CREATION_DATE => FND_API.G_MISS_DATE,
1927: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1928: X_LAST_UPDATE_DATE => p_last_update_date,
1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

1925: X_CREATED_BY => FND_API.G_MISS_NUM,
1926: X_CREATION_DATE => FND_API.G_MISS_DATE,
1927: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1928: X_LAST_UPDATE_DATE => p_last_update_date,
1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

1926: X_CREATION_DATE => FND_API.G_MISS_DATE,
1927: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1928: X_LAST_UPDATE_DATE => p_last_update_date,
1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1934: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE

Line 1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

1927: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
1928: X_LAST_UPDATE_DATE => p_last_update_date,
1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1934: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1935: );

Line 1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

1928: X_LAST_UPDATE_DATE => p_last_update_date,
1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1934: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1935: );
1936:

Line 1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

1929: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
1930: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
1931: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
1932: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
1933: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
1934: X_WH_UPDATE_DATE => p_industrial_classes_rec.WH_UPDATE_DATE
1935: );
1936:
1937: END do_update_industrial_classes;

Line 2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,

2554: X_BEGIN_DATE => p_industrial_class_app_rec.BEGIN_DATE,
2555: X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,
2556: X_END_DATE => p_industrial_class_app_rec.END_DATE,
2557: X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,
2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

Line 2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,

2555: X_PARTY_ID => p_industrial_class_app_rec.PARTY_ID,
2556: X_END_DATE => p_industrial_class_app_rec.END_DATE,
2557: X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,
2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

Line 2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

2556: X_END_DATE => p_industrial_class_app_rec.END_DATE,
2557: X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,
2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,

2557: X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,
2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

Line 2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

2558: X_CREATED_BY => hz_utility_pub.CREATED_BY,
2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

2559: X_CREATION_DATE => hz_utility_pub.CREATION_DATE,
2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2567: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,

Line 2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

2560: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2567: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2568: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,

Line 2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

2561: X_LAST_UPDATE_DATE => hz_utility_pub.LAST_UPDATE_DATE,
2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2567: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2568: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
2569: X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING

Line 2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

2562: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2563: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2564: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2565: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2566: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2567: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2568: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
2569: X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING
2570: );

Line 2658: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;

2654: RAISE FND_API.G_EXC_ERROR;
2655: END IF;
2656:
2657: -- pass back teh last update date
2658: p_last_update_date := hz_utility_pub.LAST_UPDATE_DATE;
2659:
2660: -- Bug 1428526: Should pass updated industrial class app info. to caller.
2661: -- Make sure to use values in p_industrial_class_app_rec.* when calling update table
2662: -- handler. Need to update p_industrial_class_app_rec first.

Line 2675: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,

2671: X_END_DATE => p_industrial_class_app_rec.END_DATE,
2672: X_INDUSTRIAL_CLASS_ID => p_industrial_class_app_rec.INDUSTRIAL_CLASS_ID,
2673: X_CREATED_BY => FND_API.G_MISS_NUM,
2674: X_CREATION_DATE => FND_API.G_MISS_DATE,
2675: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2676: X_LAST_UPDATE_DATE => p_last_update_date,
2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

Line 2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,

2673: X_CREATED_BY => FND_API.G_MISS_NUM,
2674: X_CREATION_DATE => FND_API.G_MISS_DATE,
2675: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2676: X_LAST_UPDATE_DATE => p_last_update_date,
2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

Line 2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,

2674: X_CREATION_DATE => FND_API.G_MISS_DATE,
2675: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2676: X_LAST_UPDATE_DATE => p_last_update_date,
2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2682: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,

Line 2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,

2675: X_LAST_UPDATE_LOGIN => hz_utility_pub.LAST_UPDATE_LOGIN,
2676: X_LAST_UPDATE_DATE => p_last_update_date,
2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2682: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2683: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,

Line 2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,

2676: X_LAST_UPDATE_DATE => p_last_update_date,
2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2682: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2683: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
2684: X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING

Line 2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,

2677: X_LAST_UPDATED_BY => hz_utility_pub.LAST_UPDATED_BY,
2678: X_REQUEST_ID => hz_utility_pub.REQUEST_ID,
2679: X_PROGRAM_APPLICATION_ID => hz_utility_pub.PROGRAM_APPLICATION_ID,
2680: X_PROGRAM_ID => hz_utility_pub.PROGRAM_ID,
2681: X_PROGRAM_UPDATE_DATE => hz_utility_pub.PROGRAM_UPDATE_DATE,
2682: X_WH_UPDATE_DATE => p_industrial_class_app_rec.WH_UPDATE_DATE,
2683: X_CONTENT_SOURCE_TYPE => p_industrial_class_app_rec.CONTENT_SOURCE_TYPE,
2684: X_IMPORTANCE_RANKING => p_industrial_class_app_rec.IMPORTANCE_RANKING
2685: );