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.CAC_SYNC_CONTACTS_PVT dependencies on CAC_SYNC_CONTACTS_PVT

Line 1: PACKAGE BODY CAC_SYNC_CONTACTS_PVT as

1: PACKAGE BODY CAC_SYNC_CONTACTS_PVT as
2: /* $Header: cacvsctb.pls 120.3.12000000.2 2007/06/29 05:49:24 vsood ship $ */
3:
4: /* Modified cursor for bug 6147530 */
5: CURSOR c_new_contacts

Line 64: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

60: , HZ_LOCATIONS LOC
61: , (SELECT CP.OWNER_TABLE_ID
62: , CP.CONTACT_POINT_ID
63: , 'WORK;VOICE' CONTACT_TYPE
64: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
65: CP.PHONE_AREA_CODE,
66: CP.PHONE_NUMBER,
67: CP.PHONE_EXTENSION) PHONE_NUMBER
68: FROM HZ_CONTACT_POINTS CP

Line 87: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

83: ) CPT_WP
84: , (SELECT CP.OWNER_TABLE_ID
85: , CP.CONTACT_POINT_ID
86: , 'HOME;VOICE' CONTACT_TYPE
87: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
88: CP.PHONE_AREA_CODE,
89: CP.PHONE_NUMBER,
90: CP.PHONE_EXTENSION) PHONE_NUMBER
91:

Line 111: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

107: ) CPT_HP
108: , (SELECT CP.OWNER_TABLE_ID
109: , CP.CONTACT_POINT_ID
110: , 'WORK;FAX' CONTACT_TYPE
111: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
112: CP.PHONE_AREA_CODE,
113: CP.PHONE_NUMBER,
114: CP.PHONE_EXTENSION) PHONE_NUMBER
115:

Line 135: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

131: ) CPT_WF
132: , (SELECT CP.OWNER_TABLE_ID
133: , CP.CONTACT_POINT_ID
134: , 'CELL;VOICE' CONTACT_TYPE
135: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
136: CP.PHONE_AREA_CODE,
137: CP.PHONE_NUMBER,
138: CP.PHONE_EXTENSION) PHONE_NUMBER
139:

Line 159: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

155: ) CPT_CELL
156: , (SELECT CP.OWNER_TABLE_ID
157: , CP.CONTACT_POINT_ID
158: , 'PAGER' CONTACT_TYPE
159: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
160: CP.PHONE_AREA_CODE,
161: CP.PHONE_NUMBER,
162: CP.PHONE_EXTENSION) PHONE_NUMBER
163:

Line 400: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

396: , CAC_SYNC_CONTACT_MAPPINGS CSPM
397: , (SELECT CP.OWNER_TABLE_ID
398: , CP.CONTACT_POINT_ID
399: , 'WORK;VOICE' CONTACT_TYPE
400: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
401: CP.PHONE_AREA_CODE,
402: CP.PHONE_NUMBER,
403: CP.PHONE_EXTENSION) PHONE_NUMBER
404: , CP.LAST_UPDATE_DATE

Line 424: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

420: ) CPT_WP
421: , (SELECT CP.OWNER_TABLE_ID
422: , CP.CONTACT_POINT_ID
423: , 'HOME;VOICE' CONTACT_TYPE
424: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
425: CP.PHONE_AREA_CODE,
426: CP.PHONE_NUMBER,
427: CP.PHONE_EXTENSION) PHONE_NUMBER
428:

Line 449: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

445: ) CPT_HP
446: , (SELECT CP.OWNER_TABLE_ID
447: , CP.CONTACT_POINT_ID
448: , 'WORK;FAX' CONTACT_TYPE
449: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
450: CP.PHONE_AREA_CODE,
451: CP.PHONE_NUMBER,
452: CP.PHONE_EXTENSION) PHONE_NUMBER
453:

Line 474: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

470: ) CPT_WF
471: , (SELECT CP.OWNER_TABLE_ID
472: , CP.CONTACT_POINT_ID
473: , 'CELL;VOICE' CONTACT_TYPE
474: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
475: CP.PHONE_AREA_CODE,
476: CP.PHONE_NUMBER,
477: CP.PHONE_EXTENSION) PHONE_NUMBER
478:

Line 499: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

495: ) CPT_CELL
496: , (SELECT CP.OWNER_TABLE_ID
497: , CP.CONTACT_POINT_ID
498: , 'PAGER' CONTACT_TYPE
499: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
500: CP.PHONE_AREA_CODE,
501: CP.PHONE_NUMBER,
502: CP.PHONE_EXTENSION) PHONE_NUMBER
503:

Line 678: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

674: , CAC_SYNC_CONTACT_MAPPINGS CSPM
675: , (SELECT CP.OWNER_TABLE_ID
676: , CP.CONTACT_POINT_ID
677: , 'WORK;VOICE' CONTACT_TYPE
678: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
679: CP.PHONE_AREA_CODE,
680: CP.PHONE_NUMBER,
681: CP.PHONE_EXTENSION) PHONE_NUMBER
682:

Line 702: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

698: ) CPT_WP
699: , (SELECT CP.OWNER_TABLE_ID
700: , CP.CONTACT_POINT_ID
701: , 'HOME;VOICE' CONTACT_TYPE
702: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
703: CP.PHONE_AREA_CODE,
704: CP.PHONE_NUMBER,
705: CP.PHONE_EXTENSION) PHONE_NUMBER
706:

Line 726: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

722: ) CPT_HP
723: , (SELECT CP.OWNER_TABLE_ID
724: , CP.CONTACT_POINT_ID
725: , 'WORK;FAX' CONTACT_TYPE
726: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
727: CP.PHONE_AREA_CODE,
728: CP.PHONE_NUMBER,
729: CP.PHONE_EXTENSION) PHONE_NUMBER
730:

Line 750: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

746: ) CPT_WF
747: , (SELECT CP.OWNER_TABLE_ID
748: , CP.CONTACT_POINT_ID
749: , 'CELL;VOICE' CONTACT_TYPE
750: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
751: CP.PHONE_AREA_CODE,
752: CP.PHONE_NUMBER,
753: CP.PHONE_EXTENSION) PHONE_NUMBER
754:

Line 774: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,

770: ) CPT_CELL
771: , (SELECT CP.OWNER_TABLE_ID
772: , CP.CONTACT_POINT_ID
773: , 'PAGER' CONTACT_TYPE
774: , CAC_SYNC_CONTACTS_PVT.FORMAT_PHONE(CP.PHONE_COUNTRY_CODE,
775: CP.PHONE_AREA_CODE,
776: CP.PHONE_NUMBER,
777: CP.PHONE_EXTENSION) PHONE_NUMBER
778:

Line 1313: END CAC_SYNC_CONTACTS_PVT;

1309:
1310: END FORMAT_PHONE;
1311:
1312:
1313: END CAC_SYNC_CONTACTS_PVT;