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.CCT_DEFAULT_LOOKUP_PUB dependencies on CCT_INTERACTIONKEYS_PUB

Line 25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;

21:
22: Function GetData(x_key_value_varr IN OUT NOCOPY CCT_KEYVALUE_VARR)
23: Return Varchar2
24: IS
25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;

Line 26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;

22: Function GetData(x_key_value_varr IN OUT NOCOPY CCT_KEYVALUE_VARR)
23: Return Varchar2
24: IS
25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

Line 27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;

23: Return Varchar2
24: IS
25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

Line 28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;

24: IS
25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;

Line 29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;

25: p_cct_object_type_1 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

Line 30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

26: p_cct_object_type_2 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

Line 31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

27: p_cct_object_type_3 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
35:

Line 32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;

28: p_cct_object_type_4 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
35:
36:

Line 33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

29: p_cct_object_type_5 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER ;
30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
35:
36:
37: p_result VARCHAR2(1):='N';

Line 34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

30: p_cct_object_type_6 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
31: p_cct_object_type_7 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
32: p_cct_object_type_8 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN ;
33: p_cct_object_type_9 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
34: p_cct_object_type_10 VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
35:
36:
37: p_result VARCHAR2(1):='N';
38: p_tmp_result VARCHAR2(4000):='N';

Line 41: p_cct_party_id_Key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

37: p_result VARCHAR2(1):='N';
38: p_tmp_result VARCHAR2(4000):='N';
39: p_object_type VARCHAR2(255);
40: p_object_value VARCHAR2(255);
41: p_cct_party_id_Key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
42: p_cct_party_name_key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
43: p_party_id NUMBER;
44: p_party_name VARCHAR2(255);
45: Begin

Line 42: p_cct_party_name_key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

38: p_tmp_result VARCHAR2(4000):='N';
39: p_object_type VARCHAR2(255);
40: p_object_value VARCHAR2(255);
41: p_cct_party_id_Key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
42: p_cct_party_name_key VARCHAR2(255):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
43: p_party_id NUMBER;
44: p_party_name VARCHAR2(255);
45: Begin
46: -- Check if Customer_ID is already present in incoming request. If yes call getPartyForObject