APPS.JTF_RS_TEAM_USAGES_PUB dependencies on JTF_RS_TEAMS_VL

Line 28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,

24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
28: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
30: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
31: X_MSG_COUNT OUT NOCOPY NUMBER,
32: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 39: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;

35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TEAM_USAGE';
38: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
39: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
40: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
41:
42: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
43:

Line 184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,

180: (P_API_VERSION IN NUMBER,
181: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
183: P_TEAM_ID IN JTF_RS_TEAM_USAGES.TEAM_ID%TYPE,
184: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
185: P_USAGE IN JTF_RS_TEAM_USAGES.USAGE%TYPE,
186: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_USAGES.OBJECT_VERSION_NUMBER%TYPE,
187: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
188: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 195: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;

191:
192: l_api_version CONSTANT NUMBER := 1.0;
193: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TEAM_USAGE';
194: l_team_id jtf_rs_team_usages.team_id%TYPE := p_team_id;
195: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
196: l_usage jtf_rs_team_usages.usage%TYPE := p_usage;
197:
198: l_team_id_out jtf_rs_team_usages.team_id%TYPE;
199: