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_CUSTOMERINIT_PUB dependencies on CCT_INTERACTIONKEYS_PUB

Line 33: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

29: , resultout in out nocopy varchar2) IS
30:
31: l_proc_name VARCHAR2(30) := 'WF_PartyIDExists';
32: l_party_id NUMBER;
33: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
34: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
35: BEGIN
36:
37: IF (funmode <> 'RUN') THEN

Line 34: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

30:
31: l_proc_name VARCHAR2(30) := 'WF_PartyIDExists';
32: l_party_id NUMBER;
33: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
34: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
35: BEGIN
36:
37: IF (funmode <> 'RUN') THEN
38: resultout := wf_engine.eng_null;

Line 92: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

88: , resultout in out nocopy varchar2) IS
89:
90: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromANI';
91: l_app_object_value VARCHAR2(255);
92: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
93: l_party_name VARCHAR2(255);
94: l_Party_ID NUMBER;
95: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

Line 95: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

91: l_app_object_value VARCHAR2(255);
92: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
93: l_party_name VARCHAR2(255);
94: l_Party_ID NUMBER;
95: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
97: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
98: BEGIN
99: -- set default result

Line 96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

92: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
93: l_party_name VARCHAR2(255);
94: l_Party_ID NUMBER;
95: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
97: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
98: BEGIN
99: -- set default result
100: resultout := wf_engine.eng_completed || ':N';

Line 97: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

93: l_party_name VARCHAR2(255);
94: l_Party_ID NUMBER;
95: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
96: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
97: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
98: BEGIN
99: -- set default result
100: resultout := wf_engine.eng_completed || ':N';
101:

Line 162: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

158: , resultout in out nocopy varchar2)IS
159:
160: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromANI_Multiple';
161: l_app_object_value VARCHAR2(255);
162: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
163: l_party_name VARCHAR2(255);
164: l_Party_ID NUMBER;
165: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

Line 165: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

161: l_app_object_value VARCHAR2(255);
162: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
163: l_party_name VARCHAR2(255);
164: l_Party_ID NUMBER;
165: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
167: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
168: BEGIN
169: -- set default result

Line 166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

162: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
163: l_party_name VARCHAR2(255);
164: l_Party_ID NUMBER;
165: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
167: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
168: BEGIN
169: -- set default result
170: resultout := wf_engine.eng_completed || ':N';

Line 167: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;

163: l_party_name VARCHAR2(255);
164: l_Party_ID NUMBER;
165: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
166: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
167: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ANI;
168: BEGIN
169: -- set default result
170: resultout := wf_engine.eng_completed || ':N';
171:

Line 225: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;

221: , resultout in out nocopy varchar2) IS
222:
223: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromPartyNumber';
224: l_app_object_Value VARCHAR2(32);
225: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
226: l_party_name VARCHAR2(255);
227: l_Party_ID NUMBER;
228: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

Line 228: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

224: l_app_object_Value VARCHAR2(32);
225: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
226: l_party_name VARCHAR2(255);
227: l_Party_ID NUMBER;
228: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
230: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
231: BEGIN
232: -- set default result

Line 229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

225: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
226: l_party_name VARCHAR2(255);
227: l_Party_ID NUMBER;
228: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
230: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
231: BEGIN
232: -- set default result
233: resultout := wf_engine.eng_completed || ':N';

Line 230: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;

226: l_party_name VARCHAR2(255);
227: l_Party_ID NUMBER;
228: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
229: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
230: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_PARTY_NUMBER;
231: BEGIN
232: -- set default result
233: resultout := wf_engine.eng_completed || ':N';
234:

Line 292: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;

288: , resultout in out nocopy varchar2) IS
289:
290: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromQuoteNumber';
291: l_app_object_Value VARCHAR2(32);
292: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
293: l_party_name VARCHAR2(255);
294: l_Party_ID NUMBER;
295: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

Line 295: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

291: l_app_object_Value VARCHAR2(32);
292: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
293: l_party_name VARCHAR2(255);
294: l_Party_ID NUMBER;
295: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
297: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
298: BEGIN
299: -- set default result

Line 296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

292: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
293: l_party_name VARCHAR2(255);
294: l_Party_ID NUMBER;
295: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
297: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
298: BEGIN
299: -- set default result
300: resultout := wf_engine.eng_completed || ':N';

Line 297: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;

293: l_party_name VARCHAR2(255);
294: l_Party_ID NUMBER;
295: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
296: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
297: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_QUOTE_NUMBER;
298: BEGIN
299: -- set default result
300: resultout := wf_engine.eng_completed || ':N';
301:

Line 355: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

351: , resultout in out nocopy varchar2) IS
352:
353: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromORDERNumber';
354: l_app_object_Value VARCHAR2(32);
355: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
356: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
357: l_party_name VARCHAR2(255);
358: l_Party_ID NUMBER;
359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;

Line 356: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

352:
353: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromORDERNumber';
354: l_app_object_Value VARCHAR2(32);
355: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
356: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
357: l_party_name VARCHAR2(255);
358: l_Party_ID NUMBER;
359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
360: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;

Line 359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;

355: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
356: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
357: l_party_name VARCHAR2(255);
358: l_Party_ID NUMBER;
359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
360: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
361: BEGIN
362: -- set default result
363: resultout := wf_engine.eng_completed || ':N';

Line 360: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;

356: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
357: l_party_name VARCHAR2(255);
358: l_Party_ID NUMBER;
359: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
360: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ORDER_NUMBER;
361: BEGIN
362: -- set default result
363: resultout := wf_engine.eng_completed || ':N';
364:

Line 418: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

414: , funmode in varchar2
415: , resultout in out nocopy varchar2) IS
416:
417: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromCollateralRequestNumber';
418: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
419: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
420: l_app_object_Value VARCHAR2(32);
421: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
422: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;

Line 419: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

415: , resultout in out nocopy varchar2) IS
416:
417: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromCollateralRequestNumber';
418: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
419: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
420: l_app_object_Value VARCHAR2(32);
421: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
422: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
423: l_party_name VARCHAR2(255);

Line 421: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;

417: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromCollateralRequestNumber';
418: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
419: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
420: l_app_object_Value VARCHAR2(32);
421: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
422: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
423: l_party_name VARCHAR2(255);
424: l_Party_ID NUMBER;
425: BEGIN

Line 422: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;

418: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
419: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
420: l_app_object_Value VARCHAR2(32);
421: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
422: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_COLLATERAL_REQUEST_NUMBER;
423: l_party_name VARCHAR2(255);
424: l_Party_ID NUMBER;
425: BEGIN
426: -- set default result

Line 482: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

478: , resultout in out nocopy varchar2) IS
479:
480: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromAccountNumber';
481: l_app_object_Value VARCHAR2(32);
482: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
483: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
484: l_party_name VARCHAR2(255);
485: l_Party_ID NUMBER;
486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

Line 483: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

479:
480: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromAccountNumber';
481: l_app_object_Value VARCHAR2(32);
482: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
483: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
484: l_party_name VARCHAR2(255);
485: l_Party_ID NUMBER;
486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
487: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

Line 486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

482: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
483: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
484: l_party_name VARCHAR2(255);
485: l_Party_ID NUMBER;
486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
487: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
488: BEGIN
489: -- set default result
490: resultout := wf_engine.eng_completed || ':N';

Line 487: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;

483: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
484: l_party_name VARCHAR2(255);
485: l_Party_ID NUMBER;
486: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
487: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_ACCOUNT_NUMBER;
488: BEGIN
489: -- set default result
490: resultout := wf_engine.eng_completed || ':N';
491:

Line 545: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

541: , resultout in out nocopy varchar2) IS
542:
543: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromEventCode';
544: l_app_object_Value VARCHAR2(32);
545: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
546: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
547: l_party_name VARCHAR2(255);
548: l_Party_ID NUMBER;
549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

Line 546: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

542:
543: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromEventCode';
544: l_app_object_Value VARCHAR2(32);
545: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
546: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
547: l_party_name VARCHAR2(255);
548: l_Party_ID NUMBER;
549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
550: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

Line 549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

545: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
546: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
547: l_party_name VARCHAR2(255);
548: l_Party_ID NUMBER;
549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
550: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
551: BEGIN
552: -- set default result
553: resultout := wf_engine.eng_completed || ':N';

Line 550: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;

546: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
547: l_party_name VARCHAR2(255);
548: l_Party_ID NUMBER;
549: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
550: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_EVENT_REGISTRATION_CODE;
551: BEGIN
552: -- set default result
553: resultout := wf_engine.eng_completed || ':N';
554:

Line 608: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

604: , resultout in out nocopy varchar2) IS
605:
606: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromMarketingPIN';
607: l_app_object_Value VARCHAR2(32);
608: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
609: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
610: l_party_name VARCHAR2(255);
611: l_Party_ID NUMBER;
612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;

Line 609: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

605:
606: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromMarketingPIN';
607: l_app_object_Value VARCHAR2(32);
608: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
609: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
610: l_party_name VARCHAR2(255);
611: l_Party_ID NUMBER;
612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
613: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;

Line 612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;

608: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
609: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
610: l_party_name VARCHAR2(255);
611: l_Party_ID NUMBER;
612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
613: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
614: BEGIN
615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';

Line 613: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;

609: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
610: l_party_name VARCHAR2(255);
611: l_Party_ID NUMBER;
612: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
613: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_MARKETING_PIN;
614: BEGIN
615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';
617:

Line 672: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

668: , resultout in out nocopy varchar2) IS
669: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromMarketingPIN';
670: l_app_object_Value VARCHAR2(32);
671: l_app_object_value2 VARCHAR2(32);
672: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
673: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
674: l_party_name VARCHAR2(255);
675: l_Party_ID NUMBER;
676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;

Line 673: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

669: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromMarketingPIN';
670: l_app_object_Value VARCHAR2(32);
671: l_app_object_value2 VARCHAR2(32);
672: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
673: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
674: l_party_name VARCHAR2(255);
675: l_Party_ID NUMBER;
676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;

Line 676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;

672: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
673: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
674: l_party_name VARCHAR2(255);
675: l_Party_ID NUMBER;
676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
678: l_cct_object_type2 VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER;
679: BEGIN
680: -- set default result

Line 677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;

673: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
674: l_party_name VARCHAR2(255);
675: l_Party_ID NUMBER;
676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
678: l_cct_object_type2 VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER;
679: BEGIN
680: -- set default result
681: resultout := wf_engine.eng_completed || ':N';

Line 678: l_cct_object_type2 VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER;

674: l_party_name VARCHAR2(255);
675: l_Party_ID NUMBER;
676: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
677: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER;
678: l_cct_object_type2 VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CONTRACT_NUMBER_MODIFIER;
679: BEGIN
680: -- set default result
681: resultout := wf_engine.eng_completed || ':N';
682:

Line 736: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

732: , resultout in out nocopy varchar2) IS
733:
734: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromServiceKey';
735: l_app_object_Value VARCHAR2(32);
736: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
737: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
738: l_party_name VARCHAR2(255);
739: l_Party_ID NUMBER;
740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

Line 737: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

733:
734: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromServiceKey';
735: l_app_object_Value VARCHAR2(32);
736: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
737: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
738: l_party_name VARCHAR2(255);
739: l_Party_ID NUMBER;
740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
741: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

Line 740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

736: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
737: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
738: l_party_name VARCHAR2(255);
739: l_Party_ID NUMBER;
740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
741: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
742: BEGIN
743: -- set default result
744: resultout := wf_engine.eng_completed || ':N';

Line 741: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;

737: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
738: l_party_name VARCHAR2(255);
739: l_Party_ID NUMBER;
740: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
741: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_KEY;
742: BEGIN
743: -- set default result
744: resultout := wf_engine.eng_completed || ':N';
745:

Line 799: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

795: , resultout in out nocopy varchar2) IS
796:
797: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromServiceReqNum';
798: l_app_object_Value VARCHAR2(32);
799: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
800: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
801: l_party_name VARCHAR2(255);
802: l_Party_ID NUMBER;
803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;

Line 800: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

796:
797: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromServiceReqNum';
798: l_app_object_Value VARCHAR2(32);
799: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
800: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
801: l_party_name VARCHAR2(255);
802: l_Party_ID NUMBER;
803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
804: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;

Line 803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;

799: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
800: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
801: l_party_name VARCHAR2(255);
802: l_Party_ID NUMBER;
803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
804: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
805: BEGIN
806: -- set default result
807: resultout := wf_engine.eng_completed || ':N';

Line 804: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;

800: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
801: l_party_name VARCHAR2(255);
802: l_Party_ID NUMBER;
803: l_app_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
804: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_SERVICE_REQUEST_NUMBER;
805: BEGIN
806: -- set default result
807: resultout := wf_engine.eng_completed || ':N';
808:

Line 863: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

859: , resultout in out nocopy varchar2)IS
860:
861: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromInvoiceNum';
862: l_app_object_Value VARCHAR2(32);
863: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
864: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
865: l_party_name VARCHAR2(255);
866: l_Party_ID NUMBER;
867: l_app_object_type VARCHAR2(64):='INVOICE_NUMBER';

Line 864: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

860:
861: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromInvoiceNum';
862: l_app_object_Value VARCHAR2(32);
863: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
864: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
865: l_party_name VARCHAR2(255);
866: l_Party_ID NUMBER;
867: l_app_object_type VARCHAR2(64):='INVOICE_NUMBER';
868: l_cct_object_type VARCHAR2(64):='INVOICENUM';

Line 926: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

922: , resultout in out nocopy varchar2)IS
923:
924: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSerialNum';
925: l_app_object_Value VARCHAR2(32);
926: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
927: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
928: l_party_name VARCHAR2(255);
929: l_Party_ID NUMBER;
930: l_app_object_type VARCHAR2(64):='SERIAL_NUMBER';

Line 927: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

923:
924: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSerialNum';
925: l_app_object_Value VARCHAR2(32);
926: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
927: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
928: l_party_name VARCHAR2(255);
929: l_Party_ID NUMBER;
930: l_app_object_type VARCHAR2(64):='SERIAL_NUMBER';
931: l_cct_object_type VARCHAR2(64):='SERIALNUM';

Line 989: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

985: , resultout in out nocopy varchar2)IS
986:
987: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSystemName';
988: l_app_object_Value VARCHAR2(32);
989: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
990: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
991: l_party_name VARCHAR2(255);
992: l_Party_ID NUMBER;
993: l_app_object_type VARCHAR2(64):='SYSTEM_NAME';

Line 990: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

986:
987: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSystemName';
988: l_app_object_Value VARCHAR2(32);
989: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
990: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
991: l_party_name VARCHAR2(255);
992: l_Party_ID NUMBER;
993: l_app_object_type VARCHAR2(64):='SYSTEM_NAME';
994: l_cct_object_type VARCHAR2(64):='SYSTEMNAME';

Line 1051: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;

1047: , funmode in varchar2
1048: , resultout in out nocopy varchar2) IS
1049: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSystemName';
1050: l_app_object_Value VARCHAR2(32);
1051: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
1052: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
1053: l_party_name VARCHAR2(255);
1054: l_Party_ID NUMBER;
1055: l_app_object_type VARCHAR2(64):='PARTY_ID';

Line 1052: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

1048: , resultout in out nocopy varchar2) IS
1049: l_proc_name VARCHAR2(64) := 'WF_PartyIDFromSystemName';
1050: l_app_object_Value VARCHAR2(32);
1051: l_cct_party_name_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_NAME;
1052: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
1053: l_party_name VARCHAR2(255);
1054: l_Party_ID NUMBER;
1055: l_app_object_type VARCHAR2(64):='PARTY_ID';
1056: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

Line 1056: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;

1052: l_cct_party_id_key VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
1053: l_party_name VARCHAR2(255);
1054: l_Party_ID NUMBER;
1055: l_app_object_type VARCHAR2(64):='PARTY_ID';
1056: l_cct_object_type VARCHAR2(64):=CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID;
1057: BEGIN
1058: -- set default result
1059: resultout := wf_engine.eng_completed || ':N';
1060: