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.PAP_CMERGE_BB2 dependencies on HZ_UTILITY_PUB

Line 137: hz_utility_pub.CREATED_BY,

133: PC.CREATED_BY,
134: PC.LAST_UPDATE_LOGIN ,
135: PC.RECORD_VERSION_NUMBER ,
136: PC.BILL_SHIP_CUSTOMER_ID,
137: hz_utility_pub.CREATED_BY,
138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY

Line 138: hz_utility_pub.CREATION_DATE,

134: PC.LAST_UPDATE_LOGIN ,
135: PC.RECORD_VERSION_NUMBER ,
136: PC.BILL_SHIP_CUSTOMER_ID,
137: hz_utility_pub.CREATED_BY,
138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY
142: FROM PA_PROJECT_CONTACTS PC

Line 139: hz_utility_pub.LAST_UPDATE_LOGIN,

135: PC.RECORD_VERSION_NUMBER ,
136: PC.BILL_SHIP_CUSTOMER_ID,
137: hz_utility_pub.CREATED_BY,
138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY
142: FROM PA_PROJECT_CONTACTS PC
143: WHERE PC.PROJECT_ID = var_project_id

Line 140: hz_utility_pub.LAST_UPDATE_DATE,

136: PC.BILL_SHIP_CUSTOMER_ID,
137: hz_utility_pub.CREATED_BY,
138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY
142: FROM PA_PROJECT_CONTACTS PC
143: WHERE PC.PROJECT_ID = var_project_id
144: AND PC.CUSTOMER_ID = var_old_customer_id

Line 141: hz_utility_pub.LAST_UPDATED_BY

137: hz_utility_pub.CREATED_BY,
138: hz_utility_pub.CREATION_DATE,
139: hz_utility_pub.LAST_UPDATE_LOGIN,
140: hz_utility_pub.LAST_UPDATE_DATE,
141: hz_utility_pub.LAST_UPDATED_BY
142: FROM PA_PROJECT_CONTACTS PC
143: WHERE PC.PROJECT_ID = var_project_id
144: AND PC.CUSTOMER_ID = var_old_customer_id
145: AND PC.CONTACT_ID >= 0

Line 320: hz_utility_pub.CREATED_BY,

316: PC.project_contact_type_code,
317: var_customer_id,
318: var_racm_customer_id,
319: 'U',
320: hz_utility_pub.CREATED_BY,
321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY

Line 321: hz_utility_pub.CREATION_DATE,

317: var_customer_id,
318: var_racm_customer_id,
319: 'U',
320: hz_utility_pub.CREATED_BY,
321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY
325: FROM pa_project_contacts PC

Line 322: hz_utility_pub.LAST_UPDATE_LOGIN,

318: var_racm_customer_id,
319: 'U',
320: hz_utility_pub.CREATED_BY,
321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY
325: FROM pa_project_contacts PC
326: WHERE PC.PROJECT_ID = var_project_id

Line 323: hz_utility_pub.LAST_UPDATE_DATE,

319: 'U',
320: hz_utility_pub.CREATED_BY,
321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY
325: FROM pa_project_contacts PC
326: WHERE PC.PROJECT_ID = var_project_id
327: AND PC.CUSTOMER_ID = var_customer_id);

Line 324: hz_utility_pub.LAST_UPDATED_BY

320: hz_utility_pub.CREATED_BY,
321: hz_utility_pub.CREATION_DATE,
322: hz_utility_pub.LAST_UPDATE_LOGIN,
323: hz_utility_pub.LAST_UPDATE_DATE,
324: hz_utility_pub.LAST_UPDATED_BY
325: FROM pa_project_contacts PC
326: WHERE PC.PROJECT_ID = var_project_id
327: AND PC.CUSTOMER_ID = var_customer_id);
328:

Line 417: hz_utility_pub.CREATED_BY,

413: PC.project_contact_type_code,
414: var_bill_ship_customer_id,
415: var_racm_customer_id,
416: 'U',
417: hz_utility_pub.CREATED_BY,
418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY

Line 418: hz_utility_pub.CREATION_DATE,

414: var_bill_ship_customer_id,
415: var_racm_customer_id,
416: 'U',
417: hz_utility_pub.CREATED_BY,
418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY
422: FROM pa_project_contacts PC

Line 419: hz_utility_pub.LAST_UPDATE_LOGIN,

415: var_racm_customer_id,
416: 'U',
417: hz_utility_pub.CREATED_BY,
418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY
422: FROM pa_project_contacts PC
423: WHERE PC.PROJECT_ID = var_project_id

Line 420: hz_utility_pub.LAST_UPDATE_DATE,

416: 'U',
417: hz_utility_pub.CREATED_BY,
418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY
422: FROM pa_project_contacts PC
423: WHERE PC.PROJECT_ID = var_project_id
424: AND PC.CUSTOMER_ID = var_customer_id

Line 421: hz_utility_pub.LAST_UPDATED_BY

417: hz_utility_pub.CREATED_BY,
418: hz_utility_pub.CREATION_DATE,
419: hz_utility_pub.LAST_UPDATE_LOGIN,
420: hz_utility_pub.LAST_UPDATE_DATE,
421: hz_utility_pub.LAST_UPDATED_BY
422: FROM pa_project_contacts PC
423: WHERE PC.PROJECT_ID = var_project_id
424: AND PC.CUSTOMER_ID = var_customer_id
425: AND PC.BILL_SHIP_CUSTOMER_ID=var_bill_ship_customer_id);