eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_RELATE_AUD_PVT dependencies on JTF_RS_GRP_RELATIONS

Line 21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,

17: PROCEDURE INSERT_GROUP_RELATE(
18: P_API_VERSION IN NUMBER,
19: P_INIT_MSG_LIST IN VARCHAR2,
20: P_COMMIT IN VARCHAR2,
21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,

18: P_API_VERSION IN NUMBER,
19: P_INIT_MSG_LIST IN VARCHAR2,
20: P_COMMIT IN VARCHAR2,
21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

19: P_INIT_MSG_LIST IN VARCHAR2,
20: P_COMMIT IN VARCHAR2,
21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

20: P_COMMIT IN VARCHAR2,
21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

21: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

22: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2 )

Line 27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

23: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
24: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
25: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
26: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
27: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
28: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
29: X_MSG_COUNT OUT NOCOPY NUMBER,
30: X_MSG_DATA OUT NOCOPY VARCHAR2 )
31: IS

Line 128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,

124: PROCEDURE UPDATE_group_RELATE(
125: P_API_VERSION IN NUMBER,
126: P_INIT_MSG_LIST IN VARCHAR2,
127: P_COMMIT IN VARCHAR2,
128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

Line 129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,

125: P_API_VERSION IN NUMBER,
126: P_INIT_MSG_LIST IN VARCHAR2,
127: P_COMMIT IN VARCHAR2,
128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

Line 130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,

126: P_INIT_MSG_LIST IN VARCHAR2,
127: P_COMMIT IN VARCHAR2,
128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

Line 131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,

127: P_COMMIT IN VARCHAR2,
128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
135: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,

128: P_GROUP_RELATE_ID IN JTF_RS_GRP_RELATIONS.GROUP_RELATE_ID %TYPE,
129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
135: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,

129: P_GROUP_ID IN JTF_RS_GRP_RELATIONS.GROUP_ID %TYPE,
130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
135: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136: X_MSG_COUNT OUT NOCOPY NUMBER,
137: X_MSG_DATA OUT NOCOPY VARCHAR2 )

Line 134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,

130: P_RELATED_GROUP_ID IN JTF_RS_GRP_RELATIONS.RELATED_GROUP_ID%TYPE,
131: P_RELATION_TYPE IN JTF_RS_GRP_RELATIONS.RELATION_TYPE%TYPE,
132: P_START_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.START_DATE_ACTIVE%TYPE,
133: P_END_DATE_ACTIVE IN JTF_RS_GRP_RELATIONS.END_DATE_ACTIVE%TYPE,
134: P_OBJECT_VERSION_NUMBER IN JTF_RS_GRP_RELATIONS.OBJECT_VERSION_NUMBER%TYPE,
135: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136: X_MSG_COUNT OUT NOCOPY NUMBER,
137: X_MSG_DATA OUT NOCOPY VARCHAR2 )
138: IS

Line 139: CURSOR rr_old_cur(l_group_relate_id JTF_RS_grp_RELATIONS.group_RELATE_ID%TYPE)

135: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
136: X_MSG_COUNT OUT NOCOPY NUMBER,
137: X_MSG_DATA OUT NOCOPY VARCHAR2 )
138: IS
139: CURSOR rr_old_cur(l_group_relate_id JTF_RS_grp_RELATIONS.group_RELATE_ID%TYPE)
140: IS
141: SELECT group_id,
142: related_group_id,
143: relation_type,

Line 147: FROM jtf_rs_grp_relations

143: relation_type,
144: start_date_active,
145: end_date_active,
146: object_version_number
147: FROM jtf_rs_grp_relations
148: WHERE group_relate_id = l_group_relate_id;
149:
150:
151: --declare variables

Line 153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;

149:
150:
151: --declare variables
152: --old value
153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;

Line 154: l_group_id jtf_rs_grp_relations.group_id %type := null;

150:
151: --declare variables
152: --old value
153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;

Line 155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;

151: --declare variables
152: --old value
153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;

Line 156: l_relation_type jtf_rs_grp_relations.relation_type%type;

152: --old value
153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
160:

Line 157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;

153: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
160:
161:

Line 158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;

154: l_group_id jtf_rs_grp_relations.group_id %type := null;
155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
160:
161:
162:

Line 159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;

155: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
156: l_relation_type jtf_rs_grp_relations.relation_type%type;
157: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
158: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
159: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
160:
161:
162:
163:

Line 165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;

161:
162:
163:
164: --new values
165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;
166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;

Line 166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;

162:
163:
164: --new values
165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;
166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;

Line 167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;

163:
164: --new values
165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;
166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;
171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;

Line 168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;

164: --new values
165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;
166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;
171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;
172:

Line 169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;

165: l_group_relate_id_n jtf_rs_grp_relations.group_relate_id %type := null;
166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;
171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;
172:
173:

Line 170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;

166: l_group_id_n jtf_rs_grp_relations.group_id %type := null;
167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;
171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;
172:
173:
174:

Line 171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;

167: l_related_group_id_n jtf_rs_grp_relations.related_group_id%type := null;
168: l_relation_type_n jtf_rs_grp_relations.relation_type%type;
169: l_start_date_active_n jtf_rs_grp_relations.start_date_active%type := null;
170: l_end_date_active_n jtf_rs_grp_relations.end_date_active%type := null;
171: l_object_version_number_n jtf_rs_grp_relations.object_version_number%type := null;
172:
173:
174:
175:

Line 324: CURSOR rr_old_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.group_RELATE_ID%TYPE)

320: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
321: X_MSG_COUNT OUT NOCOPY NUMBER,
322: X_MSG_DATA OUT NOCOPY VARCHAR2 )
323: IS
324: CURSOR rr_old_cur(l_group_relate_id JTF_RS_GRP_RELATIONS.group_RELATE_ID%TYPE)
325: IS
326: SELECT group_id,
327: related_group_id,
328: relation_type,

Line 332: FROM jtf_rs_grp_relations

328: relation_type,
329: start_date_active,
330: end_date_active,
331: object_version_number
332: FROM jtf_rs_grp_relations
333: WHERE group_relate_id = l_group_relate_id;
334:
335:
336: --declare variables

Line 338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;

334:
335:
336: --declare variables
337: --old value
338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;

Line 339: l_group_id jtf_rs_grp_relations.group_id %type := null;

335:
336: --declare variables
337: --old value
338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;

Line 340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;

336: --declare variables
337: --old value
338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;

Line 341: l_relation_type jtf_rs_grp_relations.relation_type%type;

337: --old value
338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
345:

Line 342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;

338: l_group_relate_id jtf_rs_grp_relations.group_relate_id %type := null;
339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
345:
346:

Line 343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;

339: l_group_id jtf_rs_grp_relations.group_id %type := null;
340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
345:
346:
347: rr_old_rec rr_old_cur%rowtype;

Line 344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;

340: l_related_group_id jtf_rs_grp_relations.related_group_id%type := null;
341: l_relation_type jtf_rs_grp_relations.relation_type%type;
342: l_start_date_active jtf_rs_grp_relations.start_date_active%type := null;
343: l_end_date_active jtf_rs_grp_relations.end_date_active%type := null;
344: l_object_version_number jtf_rs_grp_relations.object_version_number%type := null;
345:
346:
347: rr_old_rec rr_old_cur%rowtype;
348: l_group_relate_aud_id jtf_rs_grp_relate_aud.group_relate_audit_id%type;