APPS.CZ_IMP_SINGLE dependencies on DUAL

Line 3412: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3408:
3409:
3410: IF(inCopyRootModel = '1')THEN
3411:
3412: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3413:
3414: INSERT INTO CZ_XFR_PROJECT_BILLS
3415: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3416: source_server)

Line 3418: FROM DUAL;

3414: INSERT INTO CZ_XFR_PROJECT_BILLS
3415: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3416: source_server)
3417: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3418: FROM DUAL;
3419:
3420: ELSE
3421:
3422: IF(inRefreshModelId IS NULL OR inRefreshModelId = -1)THEN

Line 3474: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;

3470: WHERE model_ps_node_id = nModelId;
3471:
3472: ELSE
3473:
3474: SELECT CZ_XFR_PROJECT_BILLS_S.NEXTVAL INTO nModelId FROM DUAL;
3475:
3476: INSERT INTO CZ_XFR_PROJECT_BILLS
3477: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3478: source_server)

Line 3480: FROM DUAL;

3476: INSERT INTO CZ_XFR_PROJECT_BILLS
3477: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3478: source_server)
3479: SELECT inOrgId,inTopId,inExplType,'0',nModelId,inCopyChildModels,inServerId
3480: FROM DUAL;
3481:
3482: END IF;
3483:
3484: ELSE -- (inRefreshModelId IS NULL OR inRefreshModelId = -1)

Line 3497: FROM DUAL WHERE NOT EXISTS

3493: INSERT INTO CZ_XFR_PROJECT_BILLS
3494: (ORGANIZATION_ID,TOP_ITEM_ID,EXPLOSION_TYPE,DELETED_FLAG,MODEL_PS_NODE_ID,copy_addl_child_models,
3495: source_server)
3496: SELECT inOrgId,inTopId,inExplType,'0',inRefreshModelId,inCopyChildModels,inServerId
3497: FROM DUAL WHERE NOT EXISTS
3498: (SELECT NULL FROM CZ_XFR_PROJECT_BILLS WHERE model_ps_node_id = inRefreshModelId);
3499:
3500: UPDATE cz_xfr_project_bills SET
3501: deleted_flag = '0',

Line 3910: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;

3906: allowDecimalOptionClass := 0;
3907: END;
3908:
3909: BEGIN
3910: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO genRun_ID FROM DUAL;
3911: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY,COMPLETED)
3912: VALUES (genRun_ID,SYSDATE,SYSDATE,'0');
3913: x_run_id := genRun_ID;
3914: EXCEPTION

Line 3953: INTO dDateFormat FROM DUAL;

3949: END;
3950:
3951: SELECT DECODE(SUBSTR(sVersion,1,INSTR(sVersion,'.',1,2)-1),
3952: '11.5','YYYY/MM/DD HH24:MI','DD-MON-RR HH24:MI')
3953: INTO dDateFormat FROM DUAL;
3954:
3955: BEGIN
3956:
3957: v_settings_id := 'COMMITSIZE';