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_GROUPS_AUD_PVT dependencies on JTF_RS_GROUPS_B

Line 154: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

150: X_MSG_COUNT OUT NOCOPY NUMBER,
151: X_MSG_DATA OUT NOCOPY VARCHAR2,
152: P_TIME_ZONE IN NUMBER )
153: IS
154: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
155: IS
156: SELECT b.group_number ,
157: b.exclusive_flag ,
158: b.start_date_active ,

Line 173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

169:
170:
171: --declare variables
172: --old value
173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

170:
171: --declare variables
172: --old value
173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

171: --declare variables
172: --old value
173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

172: --old value
173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

173: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

174: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

Line 179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

175: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
183:

Line 182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
183:
184:
185:
186:

Line 189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

185:
186:
187:
188: --old values
189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

186:
187:
188: --old values
189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

187:
188: --old values
189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

188: --old values
189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

189: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

190: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

Line 195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

191: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
199:

Line 198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
199:
200: rr_old_rec rr_old_cur%rowtype;
201:
202: l_group_audit_id jtf_rs_groups_aud_b.group_audit_id%type;

Line 369: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

365: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
366: X_MSG_COUNT OUT NOCOPY NUMBER,
367: X_MSG_DATA OUT NOCOPY VARCHAR2 )
368: IS
369: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
370: IS
371: SELECT b.group_number ,
372: b.exclusive_flag ,
373: b.start_date_active ,

Line 387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

383:
384:
385: --declare variables
386: --old value
387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

384:
385: --declare variables
386: --old value
387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

385: --declare variables
386: --old value
387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

386: --old value
387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

387: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

388: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

Line 393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

389: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
397:

Line 396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;

392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
397:
398: rr_old_rec rr_old_cur%rowtype;
399:
400: l_group_audit_id jtf_rs_groups_aud_b.group_audit_id%type;