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 150: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)

146: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
147: X_MSG_COUNT OUT NOCOPY NUMBER,
148: X_MSG_DATA OUT NOCOPY VARCHAR2 )
149: IS
150: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
151: IS
152: SELECT b.group_number ,
153: b.exclusive_flag ,
154: b.start_date_active ,

Line 168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

164:
165:
166: --declare variables
167: --old value
168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

165:
166: --declare variables
167: --old value
168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

166: --declare variables
167: --old value
168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

167: --old value
168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

168: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

169: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
177:

Line 174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

170: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
177:
178:

Line 183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

179:
180:
181:
182: --old values
183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

180:
181:
182: --old values
183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

181:
182: --old values
183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

182: --old values
183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

183: l_group_number_n JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

184: l_exclusive_flag_n JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
192:

Line 189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

185: l_start_date_active_n JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
192:
193:

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

352: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
353: X_MSG_COUNT OUT NOCOPY NUMBER,
354: X_MSG_DATA OUT NOCOPY VARCHAR2 )
355: IS
356: CURSOR rr_old_cur(l_group_id JTF_RS_GROUPS_B.GROUP_ID%TYPE)
357: IS
358: SELECT b.group_number ,
359: b.exclusive_flag ,
360: b.start_date_active ,

Line 373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;

369:
370:
371: --declare variables
372: --old value
373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

Line 374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;

370:
371: --declare variables
372: --old value
373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

Line 375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;

371: --declare variables
372: --old value
373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

Line 376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;

372: --old value
373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

Line 377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;

373: l_group_number JTF_RS_GROUPS_B.GROUP_NUMBER%TYPE;
374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

Line 378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;

374: l_exclusive_flag JTF_RS_GROUPS_B.EXCLUSIVE_FLAG%TYPE;
375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
382:

Line 379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;

375: l_start_date_active JTF_RS_GROUPS_B.START_DATE_ACTIVE%TYPE;
376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
382:
383: rr_old_rec rr_old_cur%rowtype;