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.JUMF_LCT_PKG dependencies on JTF_UMUTIL

Line 26: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),

22:
23: begin
24: if ( x_upload_mode = 'NLS' ) then
25: JTF_UM_TEMPLATES_PKG.TRANSLATE_ROW(
26: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),
27: X_TEMPLATE_NAME => x_template_name,
28: X_DESCRIPTION => x_description,
29: X_OWNER => x_owner,
30: X_LAST_UPDATE_DATE => x_last_update_date,

Line 37: -- where TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24: MI:SS'));

33: else
34: -- select LAST_UPDATED_BY
35: -- into v_db_owner_id
36: -- from JTF_UM_TEMPLATES_B
37: -- where TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24: MI:SS'));
38:
39: -- if (v_db_owner_id = 1) then
40: JTF_UM_TEMPLATES_PKG.LOAD_ROW(
41: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 41: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),

37: -- where TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24: MI:SS'));
38:
39: -- if (v_db_owner_id = 1) then
40: JTF_UM_TEMPLATES_PKG.LOAD_ROW(
41: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),
42: X_TEMPLATE_KEY => x_template_key,
43: X_PAGE_NAME => x_page_name,
44: X_TEMPLATE_HANDLER => x_template_handler,
45: X_TEMPLATE_TYPE_CODE => x_template_type_code,

Line 61: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),

57:
58: exception
59: when no_data_found then
60: JTF_UM_TEMPLATES_PKG.LOAD_ROW(
61: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')),
62: X_TEMPLATE_KEY => x_template_key,
63: X_PAGE_NAME => x_page_name,
64: X_TEMPLATE_HANDLER => x_template_handler,
65: X_TEMPLATE_TYPE_CODE => x_template_type_code,

Line 102: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

98:
99: begin
100: if ( x_upload_mode = 'NLS' ) then
101: JTF_UM_APPROVALS_PKG.TRANSLATE_ROW(
102: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
103: X_APPROVAL_NAME => x_approval_name,
104: X_DESCRIPTION => x_description,
105: X_OWNER => x_owner,
106: X_LAST_UPDATE_DATE => x_last_update_date,

Line 113: -- where APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

109: else
110: -- select LAST_UPDATED_BY
111: -- into v_db_owner_id
112: -- from JTF_UM_APPROVALS_B
113: -- where APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
114:
115: -- if (v_db_owner_id = 1) then
116: JTF_UM_APPROVALS_PKG.LOAD_ROW(
117: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 117: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

113: -- where APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
114:
115: -- if (v_db_owner_id = 1) then
116: JTF_UM_APPROVALS_PKG.LOAD_ROW(
117: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
118: X_APPROVAL_KEY => x_approval_key,
119: X_ENABLED_FLAG => x_enabled_flag,
120: X_APPLICATION_ID => to_number(x_application_id),
121: X_WF_ITEM_TYPE => x_wf_item_type,

Line 137: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

133:
134: exception
135: when no_data_found then
136: JTF_UM_APPROVALS_PKG.LOAD_ROW(
137: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
138: X_APPROVAL_KEY => x_approval_key,
139: X_ENABLED_FLAG => x_enabled_flag,
140: X_APPLICATION_ID => to_number(x_application_id),
141: X_WF_ITEM_TYPE => x_wf_item_type,

Line 179: -- and APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

175: -- select LAST_UPDATED_BY
176: -- into v_db_owner_id
177: -- from JTF_UM_APPROVERS
178: -- where EFFECTIVE_START_DATE = to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
179: -- and APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
180: -- and USER_ID = JTF_UMUTIL.user_lookup(x_user_name);
181:
182: -- if (v_db_owner_id = 1) then
183: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(

Line 180: -- and USER_ID = JTF_UMUTIL.user_lookup(x_user_name);

176: -- into v_db_owner_id
177: -- from JTF_UM_APPROVERS
178: -- where EFFECTIVE_START_DATE = to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS')
179: -- and APPROVAL_ID = JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
180: -- and USER_ID = JTF_UMUTIL.user_lookup(x_user_name);
181:
182: -- if (v_db_owner_id = 1) then
183: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(
184: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 184: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

180: -- and USER_ID = JTF_UMUTIL.user_lookup(x_user_name);
181:
182: -- if (v_db_owner_id = 1) then
183: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(
184: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
185: X_APPROVER_SEQ => to_number(x_approver_seq),
186: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),
187: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS'),
188: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),

Line 186: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),

182: -- if (v_db_owner_id = 1) then
183: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(
184: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
185: X_APPROVER_SEQ => to_number(x_approver_seq),
186: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),
187: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS'),
188: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
189: X_OWNER => x_owner,
190: X_LAST_UPDATE_DATE => x_last_update_date,

Line 199: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

195:
196: exception
197: when no_data_found then
198: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(
199: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
200: X_APPROVER_SEQ => to_number(x_approver_seq),
201: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),
202: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS'),
203: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),

Line 201: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),

197: when no_data_found then
198: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(
199: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
200: X_APPROVER_SEQ => to_number(x_approver_seq),
201: X_USER_ID => JTF_UMUTIL.user_lookup(x_user_name),
202: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date,'YYYY/MM/DD HH24:MI:SS'),
203: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
204: X_OWNER => x_owner,
205: X_LAST_UPDATE_DATE => x_last_update_date,

Line 243: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

239:
240: begin
241: if ( x_upload_mode = 'NLS' ) then
242: JTF_UM_USERTYPES_PKG.TRANSLATE_ROW(
243: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
244: X_USERTYPE_NAME => x_usertype_name,
245: X_USERTYPE_SHORTNAME => NVL(x_usertype_shortname, 'CHANGE ME IN THE ADMIN CONSOLE: USERTYPE SETUP SCREEN'),
246: X_DESCRIPTION => x_description,
247: X_OWNER => x_owner,

Line 255: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

251: else
252: select LAST_UPDATED_BY, DISPLAY_ORDER, USERTYPE_SHORTNAME
253: into v_db_owner_id, v_db_display_order, v_db_usertype_shortname
254: from JTF_UM_USERTYPES_VL
255: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
256:
257:
258:
259: JTF_UM_USERTYPES_PKG.LOAD_ROW(

Line 261: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

257:
258:
259: JTF_UM_USERTYPES_PKG.LOAD_ROW(
260: X_USERTYPE_KEY => x_usertype_key,
261: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
262: X_IS_SELF_SERVICE_FLAG => x_is_self_service_flag,
263: X_EMAIL_NOTIFICATION_FLAG => x_email_notification_flag,
264: X_ENABLED_FLAG => x_enabled_flag,
265: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 265: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

261: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
262: X_IS_SELF_SERVICE_FLAG => x_is_self_service_flag,
263: X_EMAIL_NOTIFICATION_FLAG => x_email_notification_flag,
264: X_ENABLED_FLAG => x_enabled_flag,
265: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
266: X_APPLICATION_ID => to_number(x_application_id),
267: X_EFFECTIVE_START_DATE => to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'),
268: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
269: X_USERTYPE_NAME => x_usertype_name,

Line 287: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

283: exception
284: when no_data_found then
285: JTF_UM_USERTYPES_PKG.LOAD_ROW(
286: X_USERTYPE_KEY => x_usertype_key,
287: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
288: X_IS_SELF_SERVICE_FLAG => x_is_self_service_flag,
289: X_EMAIL_NOTIFICATION_FLAG => x_email_notification_flag,
290: X_ENABLED_FLAG => x_enabled_flag,
291: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 291: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

287: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
288: X_IS_SELF_SERVICE_FLAG => x_is_self_service_flag,
289: X_EMAIL_NOTIFICATION_FLAG => x_email_notification_flag,
290: X_ENABLED_FLAG => x_enabled_flag,
291: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
292: X_APPLICATION_ID => to_number(x_application_id),
293: X_EFFECTIVE_START_DATE => to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'),
294: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
295: X_USERTYPE_NAME => x_usertype_name,

Line 332: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

328: else
329: select count(*)
330: into v_active_record_count
331: from JTF_UM_USERTYPE_TMPL
332: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
333: and EFFECTIVE_END_DATE is NULL
334: and LAST_UPDATED_BY <> 1;
335:
336: if( v_active_record_count > 0 ) then

Line 343: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

339:
340: select LAST_UPDATED_BY
341: into v_db_owner_id
342: from JTF_UM_USERTYPE_TMPL
343: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
344: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
345: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
346:
347: if (v_active_record_count = 0) then

Line 344: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

340: select LAST_UPDATED_BY
341: into v_db_owner_id
342: from JTF_UM_USERTYPE_TMPL
343: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
344: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
345: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
346:
347: if (v_active_record_count = 0) then
348: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(

Line 349: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

345: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
346:
347: if (v_active_record_count = 0) then
348: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(
349: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
350: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
351: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
352: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
353: X_OWNER => x_owner,

Line 350: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

346:
347: if (v_active_record_count = 0) then
348: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(
349: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
350: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
351: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
352: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
353: X_OWNER => x_owner,
354: X_LAST_UPDATE_DATE => x_last_update_date,

Line 367: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

363:
364: update JTF_UM_USERTYPE_TMPL
365: set EFFECTIVE_END_DATE = SYSDATE
366: where EFFECTIVE_END_DATE is NULL
367: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
368:
369: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(
370: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
371: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 370: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

366: where EFFECTIVE_END_DATE is NULL
367: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
368:
369: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(
370: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
371: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
372: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
373: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
374: X_OWNER => x_owner,

Line 371: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

367: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
368:
369: JTF_UM_USERTYPES_PKG.LOAD_USERTYPE_TMPL_ROW(
370: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
371: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
372: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
373: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
374: X_OWNER => x_owner,
375: X_LAST_UPDATE_DATE => x_last_update_date,

Line 404: -- where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

400: ELSE
401: -- select LAST_UPDATED_BY
402: -- into v_db_owner_id
403: -- from JTF_UM_USERTYPE_ROLE
404: -- where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
405: -- and PRINCIPAL_NAME = x_principal_name
406: -- and EFFECTIVE_START_DATE = TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' );
407:
408: -- if (v_db_owner_id = 1) then

Line 410: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

406: -- and EFFECTIVE_START_DATE = TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' );
407:
408: -- if (v_db_owner_id = 1) then
409: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(
410: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
411: x_principal_name => x_principal_name ,
412: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
413: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
414: x_owner => x_owner ,

Line 424: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

420:
421: exception
422: when no_data_found then
423: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_role_ROW(
424: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
425: x_principal_name => x_principal_name ,
426: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
427: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
428: x_owner => x_owner,

Line 464: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

460: else
461: select count(*)
462: into v_active_record_count
463: from JTF_UM_USERTYPE_RESP
464: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
465: and EFFECTIVE_END_DATE is NULL
466: and LAST_UPDATED_BY <> 1;
467:
468: if( v_active_record_count > 0 ) then

Line 475: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

471:
472: select LAST_UPDATED_BY
473: into v_db_owner_id
474: from JTF_UM_USERTYPE_RESP
475: where USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
476: and RESPONSIBILITY_KEY = x_responsibility_key
477: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
478:
479: if ( v_active_record_count = 0 ) then

Line 481: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

477: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
478:
479: if ( v_active_record_count = 0 ) then
480: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(
481: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
482: x_responsibility_key => x_responsibility_key ,
483: x_is_default_flag => x_is_default_flag ,
484: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
485: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 501: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

497:
498: update JTF_UM_USERTYPE_RESP
499: set EFFECTIVE_END_DATE = SYSDATE
500: where EFFECTIVE_END_DATE is NULL
501: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
502:
503: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(
504: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
505: x_responsibility_key => x_responsibility_key ,

Line 504: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

500: where EFFECTIVE_END_DATE is NULL
501: and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
502:
503: JTF_UM_ROLE_RESP_PKG.LOAD_usertype_resp_ROW(
504: x_usertype_id => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
505: x_responsibility_key => x_responsibility_key ,
506: x_is_default_flag => x_is_default_flag ,
507: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
508: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,

Line 547: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

543:
544: BEGIN
545: if ( x_upload_mode = 'NLS' ) then
546: JTF_UM_SUBSCRIPTIONS_PKG.TRANSLATE_ROW(
547: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
548: X_SUBSCRIPTION_NAME => x_subscription_name,
549: X_DESCRIPTION => x_description,
550: X_OWNER => x_owner,
551: x_last_update_date => x_last_update_date ,

Line 557: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

553: else
554: -- select LAST_UPDATED_BY
555: -- into v_db_owner_id
556: -- from JTF_UM_SUBSCRIPTIONS_B
557: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
558:
559: -- if (v_db_owner_id = 1) then
560: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(
561: X_SUBSCRIPTION_KEY => x_subscription_key,

Line 562: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

558:
559: -- if (v_db_owner_id = 1) then
560: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(
561: X_SUBSCRIPTION_KEY => x_subscription_key,
562: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
563: X_AVAILABILITY_CODE => x_availability_code,
564: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),
565: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
566: X_APPLICATION_ID => to_number(x_application_id),

Line 565: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

561: X_SUBSCRIPTION_KEY => x_subscription_key,
562: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
563: X_AVAILABILITY_CODE => x_availability_code,
564: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),
565: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
566: X_APPLICATION_ID => to_number(x_application_id),
567: X_ENABLED_FLAG => x_enabled_flag,
568: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
569: X_AUTH_DELEGATION_ROLE_ID => to_number(x_auth_delegation_role_id),

Line 568: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

564: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),
565: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
566: X_APPLICATION_ID => to_number(x_application_id),
567: X_ENABLED_FLAG => x_enabled_flag,
568: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
569: X_AUTH_DELEGATION_ROLE_ID => to_number(x_auth_delegation_role_id),
570: X_EFFECTIVE_START_DATE => to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'),
571: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
572: X_SUBSCRIPTION_NAME => x_subscription_name,

Line 585: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

581: exception
582: when no_data_found then
583: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_ROW(
584: X_SUBSCRIPTION_KEY => x_subscription_key,
585: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
586: X_AVAILABILITY_CODE => x_availability_code,
587: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),
588: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD H
589: H24:MI:SS')),

Line 588: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD H

584: X_SUBSCRIPTION_KEY => x_subscription_key,
585: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
586: X_AVAILABILITY_CODE => x_availability_code,
587: X_LOGON_DISPLAY_FREQUENCY => to_number(x_logon_display_frequency),
588: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD H
589: H24:MI:SS')),
590: X_APPLICATION_ID => to_number(x_application_id),
591: X_ENABLED_FLAG => x_enabled_flag,
592: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 592: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

588: X_PARENT_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup_with_check(x_parent_subscription_key, to_date(x_parent_key_start_date,'YYYY/MM/DD H
589: H24:MI:SS')),
590: X_APPLICATION_ID => to_number(x_application_id),
591: X_ENABLED_FLAG => x_enabled_flag,
592: X_APPROVAL_ID => JTF_UMUTIL.approval_lookup_with_check(x_approval_key, to_date(x_approval_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
593: X_AUTH_DELEGATION_ROLE_ID => to_number(x_auth_delegation_role_id),
594: X_EFFECTIVE_START_DATE => to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'),
595: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date,'YYYY/MM/DD HH24:MI:SS'),
596: X_SUBSCRIPTION_NAME => x_subscription_name,

Line 633: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

629: else
630: select count(*)
631: into v_active_record_count
632: from JTF_UM_SUBSCRIPTION_TMPL
633: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
634: and EFFECTIVE_END_DATE is NULL
635: and LAST_UPDATED_BY <> 1;
636:
637: if( v_active_record_count > 0 ) then

Line 644: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

640:
641: select LAST_UPDATED_BY
642: into v_db_owner_id
643: from JTF_UM_SUBSCRIPTION_TMPL
644: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
645: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
646: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
647:
648: if ( v_active_record_count = 0 ) then

Line 645: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

641: select LAST_UPDATED_BY
642: into v_db_owner_id
643: from JTF_UM_SUBSCRIPTION_TMPL
644: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
645: and TEMPLATE_ID = JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
646: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
647:
648: if ( v_active_record_count = 0 ) then
649: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(

Line 650: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

646: and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
647:
648: if ( v_active_record_count = 0 ) then
649: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
650: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
651: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
652: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
653: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
654: X_OWNER => x_owner,

Line 651: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

647:
648: if ( v_active_record_count = 0 ) then
649: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
650: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
651: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
652: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
653: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
654: X_OWNER => x_owner,
655: X_LAST_UPDATE_DATE => x_last_update_date ,

Line 667: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

663:
664: update JTF_UM_SUBSCRIPTION_TMPL
665: set EFFECTIVE_END_DATE = SYSDATE
666: where EFFECTIVE_END_DATE is NULL
667: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
668:
669: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
670: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
671: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

Line 670: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

666: where EFFECTIVE_END_DATE is NULL
667: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
668:
669: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
670: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
671: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
672: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
673: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
674: X_OWNER => x_owner,

Line 671: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

667: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
668:
669: JTF_UM_SUBSCRIPTIONS_PKG.LOAD_SUBSCRIPTION_TMPL_ROW(
670: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
671: X_TEMPLATE_ID => JTF_UMUTIL.template_lookup(x_template_key, to_date(x_template_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
672: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
673: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),
674: X_OWNER => x_owner,
675: X_LAST_UPDATE_DATE => x_last_update_date ,

Line 710: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

706: ELSE
707: -- select LAST_UPDATED_BY
708: -- into v_db_owner_id
709: -- from JTF_UM_USERTYPE_SUBSCRIP
710: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
711: -- and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
712: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
713:
714: -- if (v_db_owner_id = 1) then

Line 711: -- and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

707: -- select LAST_UPDATED_BY
708: -- into v_db_owner_id
709: -- from JTF_UM_USERTYPE_SUBSCRIP
710: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
711: -- and USERTYPE_ID = JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
712: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
713:
714: -- if (v_db_owner_id = 1) then
715: JTF_UM_USERTYPES_PKG.LOAD_USERTYPES_SUB_ROW(

Line 716: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

712: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
713:
714: -- if (v_db_owner_id = 1) then
715: JTF_UM_USERTYPES_PKG.LOAD_USERTYPES_SUB_ROW(
716: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
717: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
718: X_SUBSCRIPTION_FLAG => x_subscription_flag,
719: X_DISPLAY_ORDER => to_number(x_subscription_display_order),
720: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 717: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

713:
714: -- if (v_db_owner_id = 1) then
715: JTF_UM_USERTYPES_PKG.LOAD_USERTYPES_SUB_ROW(
716: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
717: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
718: X_SUBSCRIPTION_FLAG => x_subscription_flag,
719: X_DISPLAY_ORDER => to_number(x_subscription_display_order),
720: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
721: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 732: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

728:
729: exception
730: when no_data_found then
731: JTF_UM_USERTYPES_PKG.LOAD_USERTYPES_SUB_ROW(
732: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
733: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
734: X_SUBSCRIPTION_FLAG => x_subscription_flag,
735: X_DISPLAY_ORDER => to_number(x_subscription_display_order),
736: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 733: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

729: exception
730: when no_data_found then
731: JTF_UM_USERTYPES_PKG.LOAD_USERTYPES_SUB_ROW(
732: X_USERTYPE_ID => JTF_UMUTIL.usertype_lookup(x_usertype_key, to_date(x_usertype_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
733: X_SUBSCRIPTION_ID => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
734: X_SUBSCRIPTION_FLAG => x_subscription_flag,
735: X_DISPLAY_ORDER => to_number(x_subscription_display_order),
736: X_EFFECTIVE_START_DATE => to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS'),
737: X_EFFECTIVE_END_DATE => to_date(x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS'),

Line 769: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

765:
766: -- select LAST_UPDATED_BY
767: -- into v_db_owner_id
768: -- from JTF_UM_SUBSCRIPTION_ROLE
769: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
770: -- and PRINCIPAL_NAME = x_principal_name
771: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
772:
773: -- if (v_db_owner_id = 1) then

Line 775: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

771: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
772:
773: -- if (v_db_owner_id = 1) then
774: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(
775: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
776: x_principal_name => x_principal_name ,
777: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
778: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
779: x_owner => x_owner,

Line 789: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

785:
786: exception
787: when no_data_found then
788: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_role_ROW(
789: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
790: x_principal_name => x_principal_name ,
791: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
792: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
793: x_owner => x_owner,

Line 827: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

823: else
824: select count(*)
825: into v_active_record_count
826: from JTF_UM_SUBSCRIPTION_RESP
827: where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
828: and EFFECTIVE_END_DATE is NULL
829: and LAST_UPDATED_BY <> 1;
830:
831: if( v_active_record_count > 0 ) then

Line 838: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))

834:
835: -- select LAST_UPDATED_BY
836: -- into v_db_owner_id
837: -- from JTF_UM_SUBSCRIPTION_RESP
838: -- where SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'))
839: -- and RESPONSIBILITY_KEY = x_responsibility_key
840: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
841:
842: if ( v_active_record_count = 0 ) then

Line 844: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

840: -- and EFFECTIVE_START_DATE = to_date(x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS');
841:
842: if ( v_active_record_count = 0 ) then
843: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(
844: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
845: x_responsibility_key => x_responsibility_key ,
846: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
847: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
848: x_owner => x_owner ,

Line 862: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));

858:
859: update JTF_UM_SUBSCRIPTION_RESP
860: set EFFECTIVE_END_DATE = SYSDATE
861: where EFFECTIVE_END_DATE is NULL
862: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
863:
864: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(
865: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
866: x_responsibility_key => x_responsibility_key ,

Line 865: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),

861: where EFFECTIVE_END_DATE is NULL
862: and SUBSCRIPTION_ID = JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS'));
863:
864: JTF_UM_ROLE_RESP_PKG.LOAD_subscription_resp_ROW(
865: x_subscription_id => JTF_UMUTIL.subscription_lookup(x_subscription_key, to_date(x_subscription_key_start_date,'YYYY/MM/DD HH24:MI:SS')),
866: x_responsibility_key => x_responsibility_key ,
867: x_effective_start_date => TO_DATE ( x_effective_start_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
868: x_effective_end_date => TO_DATE ( x_effective_end_date, 'YYYY/MM/DD HH24:MI:SS' ) ,
869: x_owner => x_owner ,