1 PACKAGE CCT_INTERACTIONKEYS_PUB AUTHID CURRENT_USER as
2 /* $Header: cctinkys.pls 115.8 2003/08/23 01:19:53 gvasvani noship $ */
3
4 /* Global CCT Object Type Keys */
5
6 KEY_CUSTOMER_ID VARCHAR2(64) :='PARTY_ID';
7 KEY_CUSTOMER_NAME VARCHAR2(64) :='CustomerName';
8 KEY_MEDIA_ITEM_ID VARCHAR2(64) :='occtMediaItemID';
9 KEY_ANI VARCHAR2(64) :='occtANI';
10 KEY_DNIS VARCHAR2(64) :='occtDNIS';
11 KEY_PARTY_NUMBER VARCHAR2(64) :='CustomerNum';
12 KEY_QUOTE_NUMBER VARCHAR2(64) :='QuoteNum';
13 KEY_ORDER_NUMBER VARCHAR2(64) :='OrderNum';
14 KEY_COLLATERAL_REQUEST_NUMBER VARCHAR2(64) := 'CollateralReq';
15 KEY_ACCOUNT_NUMBER VARCHAR2(64) :='AccountCode';
16 KEY_EVENT_REGISTRATION_CODE VARCHAR2(64):='EventCode';
17 KEY_MARKETING_PIN VARCHAR2(64) :='MarketingPIN';
18 KEY_SERVICE_KEY VARCHAR2(64) :='ServiceKey';
19 KEY_SERVICE_REQUEST_NUMBER VARCHAR2(64) :='ServiceRequestNum';
20 KEY_CONTRACT_NUMBER VARCHAR2(64) :='ContractNum';
21 KEY_SOURCE_CODE VARCHAR2(64) :='SourceCode';
22 KEY_CONTRACT_NUMBER_MODIFIER VARCHAR2(64) :='ContractNumModifier';
23
24
25 /* The following keys should not be seeded in CCT_INTERACTION_KEYS table
26 These keys are used internally by applications for Warm Transfer/Conference
27 and other functional processing common to E-Business Suite
28 */
29 KEY_SUBJECT_ID VARCHAR2(64) :='SubjectID'; /* Party ID of Contact Party */
30 KEY_OBJECT_ID VARCHAR2(64) :='ObjectID'; /* Party ID of Customer Party */
31 KEY_CONTACT_POINT_ID VARCHAR2(64):='ContactPointID'; /* Contact Point ID of Primary Phone */
32 KEY_PRIMARY_EMAIL_ID VARCHAR2(64) :='PrimaryEmailID'; /* Contact Point ID of Primary Email */
33 KEY_CUSTOMER_ACCOUNT_ID VARCHAR2(64) :='CustomerAccountID'; /* Account ID of Customer Party */
34 KEY_LOCATION_ID VARCHAR2(64) :='LocationID'; /* Location ID of Primary Address */
35 KEY_INTERACTION_ID VARCHAR2(64) :='InteractionID'; /* Interaction ID for an interaction */
36 KEY_ACTION_ID VARCHAR2(64) :='ActionID'; /* Action ID for the Interaction */
37
38 END CCT_INTERACTIONKEYS_PUB;