APPS.JTF_AUTH_BULKLOAD_PKG dependencies on JTF_AUTH_PRINCIPAL_MAPS

Line 52: from jtf_auth_principal_maps c,

48:
49: end if;
50:
51: select count(*) into count1
52: from jtf_auth_principal_maps c,
53: jtf_auth_principals_b a,
54: jtf_auth_domains_b d,
55: jtf_auth_principals_b b
56: where a.principal_name=U_USER_NAME and a.is_user_flag=1

Line 76: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

72: from jtf_auth_domains_b where
73: domain_name='CRM_DOMAIN';
74:
75: if count1=0 then
76: insert into jtf_auth_principal_maps (jtf_auth_principal_id,
77: jtf_auth_parent_principal_id, jtf_auth_domain_id,
78: created_by, creation_date, last_updated_by, last_update_date,
79: application_id, object_version_number) values
80: (p_id, r_id, d_id,

Line 87: from jtf_auth_principal_maps

83:
84: select jtf_auth_s1.nextval into source_id from dual;
85:
86: select jtf_auth_principal_mapping_id into mapping_id
87: from jtf_auth_principal_maps
88: where jtf_auth_principal_id = p_id
89: and jtf_auth_parent_principal_id = r_id
90: and jtf_auth_domain_id = d_id;
91:

Line 181: from jtf_auth_principal_maps c,

177:
178: end if;
179:
180: select count(*) into count1
181: from jtf_auth_principal_maps c,
182: jtf_auth_principals_b a,
183: jtf_auth_domains_b d,
184: jtf_auth_principals_b b
185: where a.principal_name=U_USER_NAME and a.is_user_flag=1

Line 206: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

202: domain_name='CRM_DOMAIN';
203:
204: if count1 = 0 then
205:
206: insert into jtf_auth_principal_maps (jtf_auth_principal_id,
207: jtf_auth_parent_principal_id, jtf_auth_domain_id,
208: created_by, creation_date, last_updated_by, last_update_date,
209: application_id, object_version_number) values
210: (p_id, r_id, d_id,

Line 218: from jtf_auth_principal_maps

214:
215: select jtf_auth_s1.nextval into source_id from dual;
216:
217: select jtf_auth_principal_mapping_id into mapping_id
218: from jtf_auth_principal_maps
219: where jtf_auth_principal_id = p_id
220: and jtf_auth_parent_principal_id = r_id
221: and jtf_auth_domain_id = d_id;
222:

Line 298: from jtf_auth_principal_maps c,

294:
295: end if;
296:
297: select count(*) into count1
298: from jtf_auth_principal_maps c,
299: jtf_auth_principals_b a,
300: jtf_auth_domains_b d,
301: jtf_auth_principals_b b
302: where a.principal_name=U_USER_NAME and a.is_user_flag=1

Line 322: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

318: from jtf_auth_domains_b where
319: domain_name='CRM_DOMAIN';
320:
321: if count1=0 then
322: insert into jtf_auth_principal_maps (jtf_auth_principal_id,
323: jtf_auth_parent_principal_id, jtf_auth_domain_id,
324: created_by, creation_date, last_updated_by, last_update_date,
325: application_id, object_version_number) values
326: (p_id, r_id, d_id,

Line 333: from jtf_auth_principal_maps

329:
330: select jtf_auth_s1.nextval into source_id from dual;
331:
332: select jtf_auth_principal_mapping_id into mapping_id
333: from jtf_auth_principal_maps
334: where jtf_auth_principal_id = p_id
335: and jtf_auth_parent_principal_id = r_id
336: and jtf_auth_domain_id = d_id;
337:

Line 428: from jtf_auth_principal_maps c,

424:
425: end if;
426:
427: select count(*) into count1
428: from jtf_auth_principal_maps c,
429: jtf_auth_principals_b a,
430: jtf_auth_domains_b d,
431: jtf_auth_principals_b b
432: where a.principal_name=U_USER_NAME and a.is_user_flag=1

Line 453: insert into jtf_auth_principal_maps (jtf_auth_principal_id,

449: domain_name='CRM_DOMAIN';
450:
451: if count1 = 0 then
452:
453: insert into jtf_auth_principal_maps (jtf_auth_principal_id,
454: jtf_auth_parent_principal_id, jtf_auth_domain_id,
455: created_by, creation_date, last_updated_by, last_update_date,
456: application_id, object_version_number) values
457: (p_id, r_id, d_id,

Line 465: from jtf_auth_principal_maps

461:
462: select jtf_auth_s1.nextval into source_id from dual;
463:
464: select jtf_auth_principal_mapping_id into mapping_id
465: from jtf_auth_principal_maps
466: where jtf_auth_principal_id = p_id
467: and jtf_auth_parent_principal_id = r_id
468: and jtf_auth_domain_id = d_id;
469: