APPS.JTF_RS_GROUP_ORGS_PKG dependencies on JTF_RS_GROUP_ORGANIZATIONS

Line 32: FROM jtf_rs_group_organizations

28: X_ATTRIBUTE_CATEGORY IN VARCHAR2
29: ) IS
30: CURSOR C IS
31: SELECT ROWID
32: FROM jtf_rs_group_organizations
33: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
34: AND GROUP_ID = X_GROUP_ID
35: ;
36: BEGIN

Line 37: INSERT INTO jtf_rs_group_organizations (

33: WHERE ORGANIZATION_ID = X_ORGANIZATION_ID
34: AND GROUP_ID = X_GROUP_ID
35: ;
36: BEGIN
37: INSERT INTO jtf_rs_group_organizations (
38: GROUP_ID,
39: ORGANIZATION_ID,
40: OBJECT_VERSION_NUMBER,
41: CREATION_DATE,

Line 106: FROM jtf_rs_group_organizations

102: X_OBJECT_VERSION_NUMBER IN NUMBER
103: ) IS
104: CURSOR c1 IS
105: SELECT OBJECT_VERSION_NUMBER
106: FROM jtf_rs_group_organizations
107: WHERE GROUP_ID = X_GROUP_ID
108: AND ORGANIZATION_ID = X_ORGANIZATION_ID
109: FOR UPDATE OF GROUP_ID NOWAIT;
110: tlinfo c1%ROWTYPE ;

Line 157: UPDATE jtf_rs_group_organizations SET

153: X_ATTRIBUTE15 IN VARCHAR2,
154: X_ATTRIBUTE_CATEGORY IN VARCHAR2
155: ) IS
156: BEGIN
157: UPDATE jtf_rs_group_organizations SET
158: GROUP_ID = X_GROUP_ID,
159: ORGANIZATION_ID = X_ORGANIZATION_ID,
160: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: DELETE FROM jtf_rs_group_organizations

190: X_GROUP_ID IN NUMBER,
191: X_ORGANIZATION_ID IN NUMBER
192: ) IS
193: BEGIN
194: DELETE FROM jtf_rs_group_organizations
195: WHERE GROUP_ID = X_GROUP_ID
196: AND ORGANIZATION_ID = X_ORGANIZATION_ID
197: ;
198: