APPS.CCT_TELESALESROUTING_PUB dependencies on WF_ENGINE

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

39: l_partyID NUMBER;
40: l_mediaItemID VARCHAR2(32);
41: BEGIN
42: -- set default result
43: resultout := wf_engine.eng_completed||':N';
44:
45: if (funmode = 'RUN') then
46: l_partyID := WF_ENGINE.GetItemAttrNumber(
47: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID));

Line 46: l_partyID := WF_ENGINE.GetItemAttrNumber(

42: -- set default result
43: resultout := wf_engine.eng_completed||':N';
44:
45: if (funmode = 'RUN') then
46: l_partyID := WF_ENGINE.GetItemAttrNumber(
47: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID));
48: l_mediaItemID := WF_ENGINE.GetItemAttrText(
49: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_MEDIA_ITEM_ID));
50:

Line 48: l_mediaItemID := WF_ENGINE.GetItemAttrText(

44:
45: if (funmode = 'RUN') then
46: l_partyID := WF_ENGINE.GetItemAttrNumber(
47: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_CUSTOMER_ID));
48: l_mediaItemID := WF_ENGINE.GetItemAttrText(
49: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_MEDIA_ITEM_ID));
50:
51:
52: IF ( (l_partyID IS NULL) OR (l_mediaItemID IS NULL) ) THEN

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

58: IF (l_agents_tbl.count = 0) THEN
59: return;
60: END IF;
61:
62: resultout := wf_engine.eng_completed||':Y';
63: CCT_RoutingWorkflow_UTL.InsertResults
64: (l_mediaItemID, l_proc_name , l_agents_tbl);
65:
66: end if;

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

101: l_SourceCode Varchar2(255);
102: l_mediaItemID VARCHAR2(32);
103: BEGIN
104: -- set default result
105: resultout := wf_engine.eng_completed||':N';
106:
107: if (funmode = 'RUN') then
108: l_SourceCode := WF_ENGINE.GetItemAttrText(
109: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_SOURCE_CODE));

Line 108: l_SourceCode := WF_ENGINE.GetItemAttrText(

104: -- set default result
105: resultout := wf_engine.eng_completed||':N';
106:
107: if (funmode = 'RUN') then
108: l_SourceCode := WF_ENGINE.GetItemAttrText(
109: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_SOURCE_CODE));
110: l_mediaItemID := WF_ENGINE.GetItemAttrText(
111: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_MEDIA_ITEM_ID));
112: --dbms_output.put_line('SourceCode='||l_sourcecode);

Line 110: l_mediaItemID := WF_ENGINE.GetItemAttrText(

106:
107: if (funmode = 'RUN') then
108: l_SourceCode := WF_ENGINE.GetItemAttrText(
109: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_SOURCE_CODE));
110: l_mediaItemID := WF_ENGINE.GetItemAttrText(
111: itemtype, itemkey, upper(CCT_INTERACTIONKEYS_PUB.KEY_MEDIA_ITEM_ID));
112: --dbms_output.put_line('SourceCode='||l_sourcecode);
113:
114: IF ( (l_SourceCode IS NULL) OR (l_mediaItemID IS NULL) ) THEN

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

120: IF (l_agents_tbl.count = 0) THEN
121: --dbms_output.put_line('result = null');
122: return;
123: END IF;
124: resultout := wf_engine.eng_completed||':Y';
125: --dbms_output.put_line('agents returned for result='||to_char(l_agents_tbl.count));
126:
127: CCT_RoutingWorkflow_UTL.InsertResults
128: (l_mediaItemID, l_proc_name , l_agents_tbl);