APPS.JTF_AUTH_BULKLOAD_PKG dependencies on DUAL

Line 46: select jtf_auth_s1.nextval into seq from dual;

42: where principal_name=U_USER_NAME and is_user_flag=1;
43:
44: if cnt=0 then
45:
46: select jtf_auth_s1.nextval into seq from dual;
47: JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,690,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);
48:
49: end if;
50:

Line 84: select jtf_auth_s1.nextval into source_id from dual;

80: (p_id, r_id, d_id,
81: 0,SYSDATE,0,SYSDATE,690,1);
82: end if;
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

Line 175: select jtf_auth_s1.nextval into seq from dual;

171: where principal_name=U_USER_NAME and is_user_flag=1;
172:
173: if cnt=0 then
174:
175: select jtf_auth_s1.nextval into seq from dual;
176: JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,690,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);
177:
178: end if;
179:

Line 215: select jtf_auth_s1.nextval into source_id from dual;

211: 0,SYSDATE,0,SYSDATE,690,1);
212:
213: end if;
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

Line 292: select jtf_auth_s1.nextval into seq from dual;

288: where principal_name=U_USER_NAME and is_user_flag=1;
289:
290: if cnt=0 then
291:
292: select jtf_auth_s1.nextval into seq from dual;
293: JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,APP_ID,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);
294:
295: end if;
296:

Line 330: select jtf_auth_s1.nextval into source_id from dual;

326: (p_id, r_id, d_id,
327: 0,SYSDATE,0,SYSDATE,APP_ID,1);
328: end if;
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

Line 422: select jtf_auth_s1.nextval into seq from dual;

418: where principal_name=U_USER_NAME and is_user_flag=1;
419:
420: if cnt=0 then
421:
422: select jtf_auth_s1.nextval into seq from dual;
423: JTF_AUTH_PRINCIPALS_PKG.INSERT_ROW(seq,seq,1,U_USER_NAME,APP_ID,null,1,0,U_USER_NAME, null, SYSDATE, 0, SYSDATE, 0, null);
424:
425: end if;
426:

Line 462: select jtf_auth_s1.nextval into source_id from dual;

458: 0,SYSDATE,0,SYSDATE,APP_ID,1);
459:
460: end if;
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