DBA Data[Home] [Help]

APPS.CCT_TELESALESROUTING_PUB dependencies on AST_ROUTING_PUB

Line 37: l_agents_tbl AST_Routing_PUB.resource_access_tbl_type;

33: , funmode in varchar2
34: , resultout in out nocopy varchar2) IS
35:
36: l_proc_name VARCHAR2(64) := 'WF_TeleSalesAgentForParty_FIL';
37: l_agents_tbl AST_Routing_PUB.resource_access_tbl_type;
38: l_num_agents NUMBER := 0;
39: l_partyID NUMBER;
40: l_mediaItemID VARCHAR2(32);
41: BEGIN

Line 56: AST_Routing_PUB.GetResourcesForParty(

52: IF ( (l_partyID IS NULL) OR (l_mediaItemID IS NULL) ) THEN
53: return;
54: END IF;
55: --call ASO API
56: AST_Routing_PUB.GetResourcesForParty(
57: l_partyID, l_agents_tbl);
58: IF (l_agents_tbl.count = 0) THEN
59: return;
60: END IF;

Line 99: l_agents_tbl AST_Routing_PUB.resource_access_tbl_type;

95: , actid in number
96: , funmode in varchar2
97: , resultout in out nocopy varchar2) IS
98: l_proc_name VARCHAR2(64) := 'WF_SalesAgentForSourceCode_FIL';
99: l_agents_tbl AST_Routing_PUB.resource_access_tbl_type;
100: l_num_agents NUMBER := 0;
101: l_SourceCode Varchar2(255);
102: l_mediaItemID VARCHAR2(32);
103: BEGIN

Line 118: AST_Routing_PUB.GetResourcesForSourceCode(

114: IF ( (l_SourceCode IS NULL) OR (l_mediaItemID IS NULL) ) THEN
115: return;
116: END IF;
117: --call ASO API
118: AST_Routing_PUB.GetResourcesForSourceCode(
119: l_SourceCode, l_agents_tbl);
120: IF (l_agents_tbl.count = 0) THEN
121: --dbms_output.put_line('result = null');
122: return;