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 ;
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;
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;
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 ;
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;
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;
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:
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:
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';
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';
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
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