APPS.CZ_IMP_PS_NODE dependencies on DUAL

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

219:
220: nAllocateCounter:=nAllocateCounter+1;
221: IF(nAllocateCounter=nAllocateBlock)THEN
222: nAllocateCounter:=0;
223: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
224: END IF;
225: nNextId := nNextValue + nAllocateCounter;
226:
227: UPDATE cz_imp_localized_texts

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

357: nAllocateCounter:=nAllocateCounter+1;
358:
359: IF(nAllocateCounter=nAllocateBlock)THEN
360: nAllocateCounter:=0;
361: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO nNextValue FROM DUAL;
362: END IF;
363: nNextId := nNextValue + nAllocateCounter;
364:
365: UPDATE cz_imp_localized_texts

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

1218: nInsertCount:=nInsertCount+1;
1219: nAllocateCounter:=nAllocateCounter+1;
1220: IF(nAllocateCounter=nAllocateBlock)THEN
1221: nAllocateCounter:=0;
1222: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
1223: END IF;
1224: nOnlDevlProjectId:=nNextValue+nAllocateCounter;
1225: END IF;
1226: END IF;

Line 1711: FROM DUAL WHERE NOT EXISTS

1707: (RULE_FOLDER_ID,NAME,TREE_SEQ,DEVL_PROJECT_ID,CREATED_BY,LAST_UPDATED_BY,
1708: CREATION_DATE,LAST_UPDATE_DATE,DELETED_FLAG)
1709: SELECT CZ_RULE_FOLDERS_S.NEXTVAL,p_xfr_devl_project.name||' Rules',0,
1710: p_xfr_devl_project.devl_project_id,UID,UID,sysdate,sysdate,'0'
1711: FROM DUAL WHERE NOT EXISTS
1712: (SELECT 1 FROM CZ_RULE_FOLDERS WHERE
1713: DEVL_PROJECT_ID=p_xfr_devl_project.devl_project_id AND
1714: PARENT_RULE_FOLDER_ID IS NULL AND NAME=p_xfr_devl_project.name||' Rules'
1715: AND deleted_flag = '0');

Line 1721: FROM DUAL WHERE NOT EXISTS

1717: INSERT INTO CZ_RP_ENTRIES
1718: (OBJECT_TYPE,OBJECT_ID,ENCLOSING_FOLDER,NAME,DESCRIPTION,DELETED_FLAG,SEEDED_FLAG)
1719: SELECT 'PRJ',p_xfr_devl_project.devl_project_id,p_rp_folder_id,
1720: p_xfr_devl_project.name,p_xfr_devl_project.desc_text,'0',p_xfr_devl_project.seeded_flag
1721: FROM DUAL WHERE NOT EXISTS
1722: (SELECT 1 FROM CZ_RP_ENTRIES WHERE deleted_flag = '0' AND (
1723: (OBJECT_TYPE='PRJ' AND OBJECT_ID=p_xfr_devl_project.devl_project_id) OR
1724: (ENCLOSING_FOLDER=p_rp_folder_id AND NAME=p_xfr_devl_project.name)));
1725:

Line 1749: FROM DUAL WHERE NOT EXISTS

1745: SELECT p_xfr_devl_project.devl_project_id, p_xfr_devl_project.desc_text,
1746: p_xfr_devl_project.top_item_id, inRUN_ID, SYSDATE,
1747: NVL(p_xfr_devl_project.ORGANIZATION_ID, 0), NVL(p_xfr_devl_project.TOP_ITEM_ID, 0),
1748: NVL(p_xfr_devl_project.EXPLOSION_TYPE, 'GENERIC'), '0', NVL(server_id, 0), '0'
1749: FROM DUAL WHERE NOT EXISTS
1750: (SELECT NULL FROM cz_xfr_project_bills
1751: WHERE model_ps_node_id = p_xfr_devl_project.devl_project_id
1752: AND deleted_flag = '0');
1753: END IF;

Line 2150: SELECT ADD_MONTHS(sysdate,300) INTO nEffUntilCap FROM DUAL;

2146: -- taking a dummy date from 25 years now in order to verify whether
2147: -- there is change to effective_until column
2148: BEGIN
2149: -- 25 years from current date
2150: SELECT ADD_MONTHS(sysdate,300) INTO nEffUntilCap FROM DUAL;
2151: EXCEPTION
2152: WHEN OTHERS THEN
2153: NULL;
2154: END;

Line 2449: FROM DUAL;

2445: DECODE(sOnlItemRefPartNbr,NULL,nImpName,
2446: DECODE(sPsNodeName,'DESCRIPTION',nImpName,sOnlItemRefPartNbr)))),
2447: DECODE(nPsNodeType,cnReference,nOnlReference,nImpReferenceId)
2448: INTO tmpOrigSysRef, tmpName, tmpReferenceId
2449: FROM DUAL;
2450:
2451:
2452:
2453: dispositionflag:=1;

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

2486: nInsertCount:=nInsertCount+1;
2487: nAllocateCounter:=nAllocateCounter+1;
2488: IF(nAllocateCounter=nAllocateBlock)THEN
2489: nAllocateCounter:=0;
2490: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
2491: END IF;
2492: nNextId := nNextValue+nAllocateCounter;
2493: nDebug := 1021;
2494:

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

2509:
2510: nAllocateCounter:=nAllocateCounter+1;
2511: IF(nAllocateCounter=nAllocateBlock)THEN
2512: nAllocateCounter:=0;
2513: SELECT CZ_PS_NODES_S.NEXTVAL INTO nNextValue FROM DUAL;
2514: END IF;
2515: nNextId := nNextValue+nAllocateCounter;
2516: nDebug := 1023;
2517: ELSE