APPS.JTF_RS_GROUP_USAGES_PUB dependencies on JTF_RS_GROUPS_VL

Line 28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_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_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
28: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
29: P_USAGE IN JTF_RS_GROUP_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_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

35:
36: l_api_version CONSTANT NUMBER := 1.0;
37: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GROUP_USAGE';
38: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
39: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
40: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
41: -- added to handle NOCOPY
42: l_group_id_out jtf_rs_group_usages.group_id%TYPE ;
43:

Line 191: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

187: (P_API_VERSION IN NUMBER,
188: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
189: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_GROUP_ID IN JTF_RS_GROUP_USAGES.GROUP_ID%TYPE,
191: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
192: P_USAGE IN JTF_RS_GROUP_USAGES.USAGE%TYPE,
193: P_OBJECT_VERSION_NUM IN JTF_RS_GROUP_USAGES.OBJECT_VERSION_NUMBER%TYPE,
194: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
195: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 202: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;

198:
199: l_api_version CONSTANT NUMBER := 1.0;
200: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_GROUP_USAGE';
201: l_group_id jtf_rs_group_usages.group_id%TYPE := p_group_id;
202: l_group_number jtf_rs_groups_vl.group_number%TYPE := p_group_number;
203: l_usage jtf_rs_group_usages.usage%TYPE := p_usage;
204:
205: -- added to handle NOCOPY
206: l_group_id_out jtf_rs_group_usages.group_id%TYPE;