APPS.JTF_AE_SQLUTIL_API dependencies on DUAL

Line 18: from dual;

14:
15: /* Step 1: First insert row in JTF_PROFILE_MAPPINGS_B table */
16: select jtf_profile_mappings_b_s1.nextVal
17: into v_pKey
18: from dual;
19:
20: JTF_AE_PROFMAPS.INSERT_ROW(
21: X_PROFILE_MAPPINGS_ID => v_pKey,
22: X_SECURITY_GROUP_ID => 0,

Line 56: from dual;

52:
53: /* Step 2: Get the nextVal for the primary key and object version */
54: select jtf_profileproperties_b_s1.NextVal
55: into v_Pkey
56: from dual;
57:
58: /* Insert into JTF_PROFILEPRPOPERTIES tables */
59: JTF_AE_PROFPROPS.INSERT_ROW (
60: X_PROFILEPROPERTIES_ID => v_PKey,

Line 100: from dual;

96:
97: /* Step 2: Get the nextVal for the primary key and object version */
98: select jtf_profileproperties_b_s1.NextVal
99: into v_Pkey
100: from dual;
101:
102: /* Insert into JTF_PROFILEPRPOPERTIES tables */
103: JTF_AE_PROFPROPS.INSERT_ROW (
104: X_PROFILEPROPERTIES_ID => v_PKey,

Line 149: from dual;

145:
146: /* Step 3: Get the nextVal for the primary key and object version */
147: select jtf_profileproperties_b_s1.NextVal
148: into p_PK
149: from dual;
150:
151: p_OID := 0;
152:
153: /* Insert into JTF_PROFILEPRPOPERTIES tables */

Line 210: from dual;

206:
207: /* Step 3: Get the nextVal for the primary key */
208: select jtf_profile_metadata_b_s1.NextVal
209: into p_PK
210: from dual;
211:
212: p_OID := 0;
213:
214: /* Insert into JTF_PROFILE_METADATA tables */

Line 377: from dual;

373:
374: /* Step 4: Rule NOT Registered .. Add the new rule */
375: select jtf_profile_rules_b_s1.NextVal
376: into v_Result
377: from dual;
378:
379: JTF_AE_PROFRULES.INSERT_ROW (
380: X_PROFILE_RULES_ID => v_Result,
381: X_SECURITY_GROUP_ID => 0,