APPS.FND_IREP_LOADER_PRIVATE dependencies on DUAL

Line 552: from dual;

548: into key_id, nice_prod,
549: nice_compat, nice_scope,
550: nice_lifecy, nice_sfprod,
551: nice_oiflag
552: from dual;
553:
554: if (P_DEST_TABLE = 'C') then
555: insert into fnd_irep_classes (
556: IREP_NAME, CLASS_TYPE, PRODUCT_CODE, DEPLOYED_FLAG,

Line 692: select P_OBJECT_NAME, P_PARENT_NAME from dual;

688: end if;
689:
690: Insert into FND_IREP_CLASS_PARENT_ASSIGNS
691: (CLASS_NAME, PARENT_CLASS_NAME)
692: select P_OBJECT_NAME, P_PARENT_NAME from dual;
693: end;
694:
695:
696:

Line 742: from dual;

738: key_id,
739: P_TYPE, P_CODE, FND_LOOKUP_ASSIGNMENTS_S.nextval,
740: f_luby, f_ludate, f_luby, f_ludate,
741: 0, P_SEQUENCE
742: from dual;
743: end;
744:
745:
746:

Line 783: from dual;

779:
780: Insert into FND_CHILD_ANNOTATIONS
781: (PARENT_ID, PARENT_FLAG, CHILD_FLAG, ANNOTATION_VALUE)
782: select key_id, P_DEST_TABLE, UPPER(P_CHILD_FLAG), P_VALUE
783: from dual;
784: end;
785:
786:
787:

Line 1096: FROM DUAL;

1092: INTO nice_ctx,
1093: nice_scope, nice_lifecy,
1094: nice_compat, nice_synch,
1095: nice_direct, nice_sdescr
1096: FROM DUAL;
1097: SELECT C.class_id, C.last_updated_by, C.last_update_date,
1098: F.FUNCTION_ID
1099: INTO key_id, f_luby, f_ludate, fn_id
1100: FROM FND_IREP_CLASSES C, FND_FORM_FUNCTIONS F

Line 1648: select fnd_menus_s.nextval into t_menu_id from dual;

1644: error1 varchar2(300);
1645: menu_com_request_status varchar2(30);
1646: BEGIN
1647: --t_menu_id := fnd_menus_s.nextval;
1648: select fnd_menus_s.nextval into t_menu_id from dual;
1649: IF v_fnd_form_functions is not null and v_fnd_form_functions.COUNT > 0 THEN
1650:
1651: FOR i IN v_fnd_form_functions.FIRST .. v_fnd_form_functions.LAST
1652: LOOP

Line 1727: FROM dual;

1723: IF v_fnd_grants(l).menu_id = v_fnd_menus(m).menu_id THEN
1724:
1725: SELECT sys_guid()
1726: INTO l_grant_guid
1727: FROM dual;
1728:
1729: fnd_grants_pkg.insert_row(x_rowid,
1730: l_grant_guid,
1731: v_fnd_grants(l).grantee_type,