DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM dependencies on DUAL

Line 32: from sys.dual;

28:
29: /* Get new ID */
30: select FND_OAM_DS_POLICIES_S.nextval
31: into policyid
32: from sys.dual;
33:
34: /*insert into the base table*/
35:
36: insert into FND_OAM_DS_POLICIES_B (

Line 167: from sys.dual;

163:
164: /* Get new ID */
165: select FND_OAM_DS_PSETS_S.nextval
166: into psetid
167: from sys.dual;
168:
169: /*insert*/
170:
171: insert into FND_OAM_DS_PSETS_B (

Line 303: from sys.dual;

299:
300: /* Get new ID */
301: select FND_OAM_DS_POLICY_ELMNTS_S.nextval
302: into elementid
303: from sys.dual;
304:
305: /*insert*/
306:
307: insert into FND_OAM_DS_POLICY_ELMNTS(

Line 368: from sys.dual;

364:
365: /* Get new ID */
366: select FND_OAM_DS_POLICY_ELMNTS_S.nextval
367: into elementid
368: from sys.dual;
369:
370: /*insert*/
371:
372: insert into FND_OAM_DS_POLICY_ELMNTS(

Line 413: from sys.dual;

409:
410: /* Get new ID */
411: select FND_OAM_DS_PSET_ELMNTS_S.nextval
412: into elementid
413: from sys.dual;
414:
415: /*insert*/
416:
417: insert into FND_OAM_DS_PSET_ELMNTS(

Line 482: from sys.dual;

478:
479: /* Get new ID */
480: select FND_OAM_DS_DELETES_S.nextval
481: into deleteid
482: from sys.dual;
483:
484: --truncate flag, value can be "T" or "F". the default is "F"
485: v_use_truncate_flag := NVL(l_use_truncate_flag, 'F');
486:

Line 719: from sys.dual;

715:
716: /* Get new ID */
717: select FND_OAM_DS_ATTRI_S.nextval
718: into aid
719: from sys.dual;
720:
721: /*construct the attribute code */
722: attribute_code := 'DSCRAM_'||to_char(aid);
723: