APPS.JUMF_LCT_PKG dependencies on JTF_UM_APPROVALS_PKG

Line 101: JTF_UM_APPROVALS_PKG.TRANSLATE_ROW(

97: v_db_owner_id number;
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,

Line 116: JTF_UM_APPROVALS_PKG.LOAD_ROW(

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')),
118: X_APPROVAL_KEY => x_approval_key,
119: X_ENABLED_FLAG => x_enabled_flag,
120: X_APPLICATION_ID => to_number(x_application_id),

Line 136: JTF_UM_APPROVALS_PKG.LOAD_ROW(

132: end if;
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),

Line 183: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(

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')),
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'),

Line 198: JTF_UM_APPROVALS_PKG.LOAD_APPROVERS_ROW(

194: END IF;
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'),