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_OTHERATTRIBINIT_PUB dependencies on WF_ENGINE

Line 33: resultout := wf_engine.eng_null;

29: l_cct_party_id_key VARCHAR2(64):='SERVICEREQUESTNUM';
30: BEGIN
31:
32: IF (funmode <> 'RUN') THEN
33: resultout := wf_engine.eng_null;
34: return;
35: end if;
36:
37: -- set default result

Line 38: resultout := wf_engine.eng_completed || ':N';

34: return;
35: end if;
36:
37: -- set default result
38: resultout := wf_engine.eng_completed || ':N';
39:
40: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
41: if (l_party_id IS NOT NULL) then
42: resultout := wf_engine.eng_completed || ':Y';

Line 40: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

36:
37: -- set default result
38: resultout := wf_engine.eng_completed || ':N';
39:
40: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
41: if (l_party_id IS NOT NULL) then
42: resultout := wf_engine.eng_completed || ':Y';
43: end if;
44:

Line 42: resultout := wf_engine.eng_completed || ':Y';

38: resultout := wf_engine.eng_completed || ':N';
39:
40: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
41: if (l_party_id IS NOT NULL) then
42: resultout := wf_engine.eng_completed || ':Y';
43: end if;
44:
45: EXCEPTION
46: WHEN OTHERS THEN

Line 86: resultout := wf_engine.eng_null;

82: l_cct_party_id_key VARCHAR2(64):='ACCOUNTCODE';
83: BEGIN
84:
85: IF (funmode <> 'RUN') THEN
86: resultout := wf_engine.eng_null;
87: return;
88: end if;
89:
90: -- set default result

Line 91: resultout := wf_engine.eng_completed || ':N';

87: return;
88: end if;
89:
90: -- set default result
91: resultout := wf_engine.eng_completed || ':N';
92:
93: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
94: if (l_party_id IS NOT NULL) then
95: resultout := wf_engine.eng_completed || ':Y';

Line 93: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

89:
90: -- set default result
91: resultout := wf_engine.eng_completed || ':N';
92:
93: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
94: if (l_party_id IS NOT NULL) then
95: resultout := wf_engine.eng_completed || ':Y';
96: end if;
97:

Line 95: resultout := wf_engine.eng_completed || ':Y';

91: resultout := wf_engine.eng_completed || ':N';
92:
93: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
94: if (l_party_id IS NOT NULL) then
95: resultout := wf_engine.eng_completed || ':Y';
96: end if;
97:
98: EXCEPTION
99: WHEN OTHERS THEN

Line 139: resultout := wf_engine.eng_null;

135: l_cct_party_id_key VARCHAR2(64):='OCCTANI';
136: BEGIN
137:
138: IF (funmode <> 'RUN') THEN
139: resultout := wf_engine.eng_null;
140: return;
141: end if;
142:
143: -- set default result

Line 144: resultout := wf_engine.eng_completed || ':N';

140: return;
141: end if;
142:
143: -- set default result
144: resultout := wf_engine.eng_completed || ':N';
145:
146: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
147: if (l_party_id IS NOT NULL) then
148: resultout := wf_engine.eng_completed || ':Y';

Line 146: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

142:
143: -- set default result
144: resultout := wf_engine.eng_completed || ':N';
145:
146: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
147: if (l_party_id IS NOT NULL) then
148: resultout := wf_engine.eng_completed || ':Y';
149: end if;
150:

Line 148: resultout := wf_engine.eng_completed || ':Y';

144: resultout := wf_engine.eng_completed || ':N';
145:
146: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
147: if (l_party_id IS NOT NULL) then
148: resultout := wf_engine.eng_completed || ':Y';
149: end if;
150:
151: EXCEPTION
152: WHEN OTHERS THEN

Line 193: resultout := wf_engine.eng_null;

189: l_cct_party_id_key VARCHAR2(64):='CollateralReq';
190: BEGIN
191:
192: IF (funmode <> 'RUN') THEN
193: resultout := wf_engine.eng_null;
194: return;
195: end if;
196:
197: -- set default result

Line 198: resultout := wf_engine.eng_completed || ':N';

194: return;
195: end if;
196:
197: -- set default result
198: resultout := wf_engine.eng_completed || ':N';
199:
200: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
201: if (l_party_id IS NOT NULL) then
202: resultout := wf_engine.eng_completed || ':Y';

Line 200: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

196:
197: -- set default result
198: resultout := wf_engine.eng_completed || ':N';
199:
200: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
201: if (l_party_id IS NOT NULL) then
202: resultout := wf_engine.eng_completed || ':Y';
203: end if;
204:

Line 202: resultout := wf_engine.eng_completed || ':Y';

198: resultout := wf_engine.eng_completed || ':N';
199:
200: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
201: if (l_party_id IS NOT NULL) then
202: resultout := wf_engine.eng_completed || ':Y';
203: end if;
204:
205: EXCEPTION
206: WHEN OTHERS THEN

Line 246: resultout := wf_engine.eng_null;

242: l_cct_party_id_key VARCHAR2(64):='ContractNum';
243: BEGIN
244:
245: IF (funmode <> 'RUN') THEN
246: resultout := wf_engine.eng_null;
247: return;
248: end if;
249:
250: -- set default result

Line 251: resultout := wf_engine.eng_completed || ':N';

247: return;
248: end if;
249:
250: -- set default result
251: resultout := wf_engine.eng_completed || ':N';
252:
253: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
254: if (l_party_id IS NOT NULL) then
255: resultout := wf_engine.eng_completed || ':Y';

Line 253: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

249:
250: -- set default result
251: resultout := wf_engine.eng_completed || ':N';
252:
253: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
254: if (l_party_id IS NOT NULL) then
255: resultout := wf_engine.eng_completed || ':Y';
256: end if;
257:

Line 255: resultout := wf_engine.eng_completed || ':Y';

251: resultout := wf_engine.eng_completed || ':N';
252:
253: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
254: if (l_party_id IS NOT NULL) then
255: resultout := wf_engine.eng_completed || ':Y';
256: end if;
257:
258: EXCEPTION
259: WHEN OTHERS THEN

Line 299: resultout := wf_engine.eng_null;

295: l_cct_party_id_key VARCHAR2(64):='EventCode';
296: BEGIN
297:
298: IF (funmode <> 'RUN') THEN
299: resultout := wf_engine.eng_null;
300: return;
301: end if;
302:
303: -- set default result

Line 304: resultout := wf_engine.eng_completed || ':N';

300: return;
301: end if;
302:
303: -- set default result
304: resultout := wf_engine.eng_completed || ':N';
305:
306: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
307: if (l_party_id IS NOT NULL) then
308: resultout := wf_engine.eng_completed || ':Y';

Line 306: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

302:
303: -- set default result
304: resultout := wf_engine.eng_completed || ':N';
305:
306: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
307: if (l_party_id IS NOT NULL) then
308: resultout := wf_engine.eng_completed || ':Y';
309: end if;
310:

Line 308: resultout := wf_engine.eng_completed || ':Y';

304: resultout := wf_engine.eng_completed || ':N';
305:
306: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
307: if (l_party_id IS NOT NULL) then
308: resultout := wf_engine.eng_completed || ':Y';
309: end if;
310:
311: EXCEPTION
312: WHEN OTHERS THEN

Line 351: resultout := wf_engine.eng_null;

347: l_cct_party_id_key VARCHAR2(64):='MarketingPIN';
348: BEGIN
349:
350: IF (funmode <> 'RUN') THEN
351: resultout := wf_engine.eng_null;
352: return;
353: end if;
354:
355: -- set default result

Line 356: resultout := wf_engine.eng_completed || ':N';

352: return;
353: end if;
354:
355: -- set default result
356: resultout := wf_engine.eng_completed || ':N';
357:
358: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
359: if (l_party_id IS NOT NULL) then
360: resultout := wf_engine.eng_completed || ':Y';

Line 358: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

354:
355: -- set default result
356: resultout := wf_engine.eng_completed || ':N';
357:
358: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
359: if (l_party_id IS NOT NULL) then
360: resultout := wf_engine.eng_completed || ':Y';
361: end if;
362:

Line 360: resultout := wf_engine.eng_completed || ':Y';

356: resultout := wf_engine.eng_completed || ':N';
357:
358: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
359: if (l_party_id IS NOT NULL) then
360: resultout := wf_engine.eng_completed || ':Y';
361: end if;
362:
363: EXCEPTION
364: WHEN OTHERS THEN

Line 404: resultout := wf_engine.eng_null;

400: l_cct_party_id_key VARCHAR2(64):='OrderNum';
401: BEGIN
402:
403: IF (funmode <> 'RUN') THEN
404: resultout := wf_engine.eng_null;
405: return;
406: end if;
407:
408: -- set default result

Line 409: resultout := wf_engine.eng_completed || ':N';

405: return;
406: end if;
407:
408: -- set default result
409: resultout := wf_engine.eng_completed || ':N';
410:
411: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
412: if (l_party_id IS NOT NULL) then
413: resultout := wf_engine.eng_completed || ':Y';

Line 411: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

407:
408: -- set default result
409: resultout := wf_engine.eng_completed || ':N';
410:
411: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
412: if (l_party_id IS NOT NULL) then
413: resultout := wf_engine.eng_completed || ':Y';
414: end if;
415:

Line 413: resultout := wf_engine.eng_completed || ':Y';

409: resultout := wf_engine.eng_completed || ':N';
410:
411: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
412: if (l_party_id IS NOT NULL) then
413: resultout := wf_engine.eng_completed || ':Y';
414: end if;
415:
416: EXCEPTION
417: WHEN OTHERS THEN

Line 456: resultout := wf_engine.eng_null;

452: l_cct_party_id_key VARCHAR2(64):='CustomerNum';
453: BEGIN
454:
455: IF (funmode <> 'RUN') THEN
456: resultout := wf_engine.eng_null;
457: return;
458: end if;
459:
460: -- set default result

Line 461: resultout := wf_engine.eng_completed || ':N';

457: return;
458: end if;
459:
460: -- set default result
461: resultout := wf_engine.eng_completed || ':N';
462:
463: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
464: if (l_party_id IS NOT NULL) then
465: resultout := wf_engine.eng_completed || ':Y';

Line 463: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

459:
460: -- set default result
461: resultout := wf_engine.eng_completed || ':N';
462:
463: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
464: if (l_party_id IS NOT NULL) then
465: resultout := wf_engine.eng_completed || ':Y';
466: end if;
467:

Line 465: resultout := wf_engine.eng_completed || ':Y';

461: resultout := wf_engine.eng_completed || ':N';
462:
463: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
464: if (l_party_id IS NOT NULL) then
465: resultout := wf_engine.eng_completed || ':Y';
466: end if;
467:
468: EXCEPTION
469: WHEN OTHERS THEN

Line 508: resultout := wf_engine.eng_null;

504: l_cct_party_id_key VARCHAR2(64):='QuoteNum';
505: BEGIN
506:
507: IF (funmode <> 'RUN') THEN
508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511:
512: -- set default result

Line 513: resultout := wf_engine.eng_completed || ':N';

509: return;
510: end if;
511:
512: -- set default result
513: resultout := wf_engine.eng_completed || ':N';
514:
515: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
516: if (l_party_id IS NOT NULL) then
517: resultout := wf_engine.eng_completed || ':Y';

Line 515: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

511:
512: -- set default result
513: resultout := wf_engine.eng_completed || ':N';
514:
515: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
516: if (l_party_id IS NOT NULL) then
517: resultout := wf_engine.eng_completed || ':Y';
518: end if;
519:

Line 517: resultout := wf_engine.eng_completed || ':Y';

513: resultout := wf_engine.eng_completed || ':N';
514:
515: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
516: if (l_party_id IS NOT NULL) then
517: resultout := wf_engine.eng_completed || ':Y';
518: end if;
519:
520: EXCEPTION
521: WHEN OTHERS THEN

Line 560: resultout := wf_engine.eng_null;

556: l_cct_party_id_key VARCHAR2(64):='ServiceKey';
557: BEGIN
558:
559: IF (funmode <> 'RUN') THEN
560: resultout := wf_engine.eng_null;
561: return;
562: end if;
563:
564: -- set default result

Line 565: resultout := wf_engine.eng_completed || ':N';

561: return;
562: end if;
563:
564: -- set default result
565: resultout := wf_engine.eng_completed || ':N';
566:
567: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
568: if (l_party_id IS NOT NULL) then
569: resultout := wf_engine.eng_completed || ':Y';

Line 567: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));

563:
564: -- set default result
565: resultout := wf_engine.eng_completed || ':N';
566:
567: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
568: if (l_party_id IS NOT NULL) then
569: resultout := wf_engine.eng_completed || ':Y';
570: end if;
571:

Line 569: resultout := wf_engine.eng_completed || ':Y';

565: resultout := wf_engine.eng_completed || ':N';
566:
567: l_party_id := WF_ENGINE.GetItemAttrNumber(itemtype,itemkey,upper(l_cct_party_id_key));
568: if (l_party_id IS NOT NULL) then
569: resultout := wf_engine.eng_completed || ':Y';
570: end if;
571:
572: EXCEPTION
573: WHEN OTHERS THEN

Line 611: resultout := wf_engine.eng_null;

607: l_cct_party_id_key VARCHAR2(64):='SourceCode';
608: BEGIN
609:
610: IF (funmode <> 'RUN') THEN
611: resultout := wf_engine.eng_null;
612: return;
613: end if;
614:
615: -- set default result

Line 616: resultout := wf_engine.eng_completed || ':N';

612: return;
613: end if;
614:
615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';
617:
618: l_source_code := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_party_id_key));
619: --dbms_output.put_line('SourceCodeexists?='||l_source_code);
620: if (l_source_code IS NOT NULL) then

Line 618: l_source_code := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_party_id_key));

614:
615: -- set default result
616: resultout := wf_engine.eng_completed || ':N';
617:
618: l_source_code := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_party_id_key));
619: --dbms_output.put_line('SourceCodeexists?='||l_source_code);
620: if (l_source_code IS NOT NULL) then
621: resultout := wf_engine.eng_completed || ':Y';
622: end if;

Line 621: resultout := wf_engine.eng_completed || ':Y';

617:
618: l_source_code := WF_ENGINE.GetItemAttrText(itemtype,itemkey,upper(l_cct_party_id_key));
619: --dbms_output.put_line('SourceCodeexists?='||l_source_code);
620: if (l_source_code IS NOT NULL) then
621: resultout := wf_engine.eng_completed || ':Y';
622: end if;
623:
624: EXCEPTION
625: WHEN OTHERS THEN