APPS.CZ_IMP_PS_NODE dependencies on DUAL

Line 171: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;

167:
168: nAllocateCounter:=nAllocateCounter+1;
169: IF(nAllocateCounter=nAllocateBlock)THEN
170: nAllocateCounter:=0;
171: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
172: END IF;
173: nNextId := nNextValue + nAllocateCounter;
174:
175: UPDATE cz_imp_localized_texts

Line 258: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;

254: nAllocateCounter:=nAllocateCounter+1;
255:
256: IF(nAllocateCounter=nAllocateBlock)THEN
257: nAllocateCounter:=0;
258: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
259: END IF;
260: nNextId := nNextValue + nAllocateCounter;
261:
262: UPDATE cz_imp_localized_texts

Line 1012: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;

1008: nInsertCount:=nInsertCount+1;
1009: nAllocateCounter:=nAllocateCounter+1;
1010: IF(nAllocateCounter=nAllocateBlock)THEN
1011: nAllocateCounter:=0;
1012: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
1013: END IF;
1014: nOnlDevlProjectId:=nNextValue+nAllocateCounter;
1015: END IF;
1016: END IF;

Line 1462: FROM DUAL WHERE NOT EXISTS

1458: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1459: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1460: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1461: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1462: FROM DUAL WHERE NOT EXISTS
1463: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
1464: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND
1465: PARENT_RULE_FOLDER_ID IS NULL AND NAME=p_xfr_devl_project.name||' Rules'
1466: AND deleted_flag = '0');

Line 1472: FROM DUAL WHERE NOT EXISTS

1468: INSERT INTO CZ_RP_ENTRIES
1469: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1470: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1471: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1472: FROM DUAL WHERE NOT EXISTS
1473: (SELECT 1 FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' AND (
1474: (OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id) OR
1475: (ENCLOSING_FOLDER=p_rp_folder_id AND NAME=p_xfr_devl_project.name)));
1476:

Line 1500: FROM DUAL WHERE NOT EXISTS

1496: SELECT p_xfr_devl_project.devl_project_id, p_xfr_devl_project.desc_text,
1497: p_xfr_devl_project.top_item_id, inRUN_ID, SYSDATE,
1498: NVL(p_xfr_devl_project.ORGANIZATION_ID, 0), NVL(p_xfr_devl_project.TOP_ITEM_ID, 0),
1499: NVL(p_xfr_devl_project.EXPLOSION_TYPE, 'GENERIC'), '0', NVL(server_id, 0), '0'
1500: FROM DUAL WHERE NOT EXISTS
1501: (SELECT NULL FROM cz_xfr_project_bills
1502: WHERE model_ps_node_id = p_xfr_devl_project.devl_project_id
1503: AND deleted_flag = '0');
1504: END IF;

Line 2100: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;

2096: nInsertCount:=nInsertCount+1;
2097: nAllocateCounter:=nAllocateCounter+1;
2098: IF(nAllocateCounter=nAllocateBlock)THEN
2099: nAllocateCounter:=0;
2100: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
2101: END IF;
2102: nNextId := nNextValue+nAllocateCounter;
2103: nDebug := 1021;
2104: ELSE

Line 2123: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;

2119:
2120: nAllocateCounter:=nAllocateCounter+1;
2121: IF(nAllocateCounter=nAllocateBlock)THEN
2122: nAllocateCounter:=0;
2123: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
2124: END IF;
2125: nNextId := nNextValue+nAllocateCounter;
2126: nDebug := 1023;
2127: ELSE