APPS.CCT_SRSEC_CHECK_PUB dependencies on CCT_AGENT_RESP_APP_ID_NST

Line 7: --procedure TestSRSecurityT(p_table IN OUT NOCOPY System.CCT_AGENT_RESP_APP_ID_NST )

3: procedure authenticate_agents(p_srnum IN Varchar2,
4: p_agentIDs IN OUT NOCOPY Varchar2,
5: p_isServerGroupID IN Varchar2,
6: x_return_status OUT NOCOPY Varchar2)
7: --procedure TestSRSecurityT(p_table IN OUT NOCOPY System.CCT_AGENT_RESP_APP_ID_NST )
8: IS
9: i BINARY_INTEGER;
10: totalRec BINARY_INTEGER;
11: status varchar2(1);

Line 16: p_table System.CCT_AGENT_RESP_APP_ID_NST;

12: agentID NUMBER(15,0);
13: respID NUMBER(15,0);
14: appID NUMBER(15,0);
15: secFlag Varchar2(1);
16: p_table System.CCT_AGENT_RESP_APP_ID_NST;
17: p_obj System.CCT_AGENT_RESP_APP_ID_OBJ;
18: l_agentIDs Varchar2(32767);
19:
20: --TYPE cur_typ IS REF CURSOR;

Line 40: p_table := System.CCT_AGENT_RESP_APP_ID_NST(System.CCT_AGENT_RESP_APP_ID_OBJ(0,0,0,''));

36: /* respID:=obj.RESPONSIBILITY_ID; */
37: /* appID:=obj.APPLICATION_ID; */
38: /* secFlag:=obj.SECURITY_YN_FLAG; */
39:
40: p_table := System.CCT_AGENT_RESP_APP_ID_NST(System.CCT_AGENT_RESP_APP_ID_OBJ(0,0,0,''));
41: i := p_table.FIRST;
42: --tbd : change "F" to "T" as that's what we want here..
43: -- If p_isServerGroupID is true, then p_agentIDs represents "Super Server Group ID".
44: -- p_agentIDs := '('||p_agentIDs||')'; Bug 4283551 - do not use literal in sql. replaced with cursor

Line 153: procedure CallSRSecurityCheck(p_srnum IN Varchar2,p_table in out NOCOPY system.CCT_AGENT_RESP_APP_ID_NST, x_return_status out NOCOPY varchar2)

149: END IF;
150: x_return_status := FND_API.G_FALSE;
151: END authenticate_agents;
152:
153: procedure CallSRSecurityCheck(p_srnum IN Varchar2,p_table in out NOCOPY system.CCT_AGENT_RESP_APP_ID_NST, x_return_status out NOCOPY varchar2)
154: IS
155: l_ver NUMBER(15,0);
156: l_srKeyName Varchar2(64);
157: status NUMERIC;