DBA Data[Home] [Help]

APPS.JTF_RS_TEAM_MEMBERS_PUB dependencies on JTF_RS_TEAMS_VL

Line 29: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,

25: (P_API_VERSION IN NUMBER,
26: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
28: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
29: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
30: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
31: P_TEAM_RESOURCE_NUMBER IN NUMBER,
32: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
33: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

38:
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RESOURCE_TEAM_MEMBERS';
41: l_team_id jtf_rs_team_members.team_id%TYPE := p_team_id;
42: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
43: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE := p_team_resource_id;
44: l_team_resource_number NUMBER := p_team_resource_number;
45: l_resource_type jtf_rs_team_members.resource_type%TYPE := upper(p_resource_type);
46: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;

Line 240: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,

236: (P_API_VERSION IN NUMBER,
237: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
238: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
239: P_TEAM_ID IN JTF_RS_TEAM_MEMBERS.TEAM_ID%TYPE,
240: P_TEAM_NUMBER IN JTF_RS_TEAMS_VL.TEAM_NUMBER%TYPE,
241: P_TEAM_RESOURCE_ID IN JTF_RS_TEAM_MEMBERS.TEAM_RESOURCE_ID%TYPE,
242: P_TEAM_RESOURCE_NUMBER IN NUMBER,
243: P_RESOURCE_TYPE IN JTF_RS_TEAM_MEMBERS.RESOURCE_TYPE%TYPE,
244: P_OBJECT_VERSION_NUM IN JTF_RS_TEAM_MEMBERS.OBJECT_VERSION_NUMBER%TYPE,

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

249:
250: l_api_version CONSTANT NUMBER := 1.0;
251: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RESOURCE_TEAM_MEMBERS';
252: l_team_id jtf_rs_team_members.team_id%TYPE := p_team_id;
253: l_team_number jtf_rs_teams_vl.team_number%TYPE := p_team_number;
254: l_team_resource_id jtf_rs_team_members.team_resource_id%TYPE := p_team_resource_id;
255: l_team_resource_number NUMBER := p_team_resource_number;
256: l_resource_type jtf_rs_team_members.resource_type%TYPE := upper(p_resource_type);
257: l_team_member_id jtf_rs_team_members.team_member_id%TYPE;