APPS.CZ_IMP_PS_NODE dependencies on CZ_PS_NODES_S

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 2483: UPDATE cz_ps_nodes SET deleted_flag='1' WHERE ps_node_id = nOnlPsnodeId;

2479: to update model_ref_expl_id of rules' participants
2480:
2481: IF(nPsNodeType = cnReference)THEN
2482:
2483: UPDATE cz_ps_nodes SET deleted_flag='1' WHERE ps_node_id = nOnlPsnodeId;
2484: cz_refs.delete_Node(nOnlPsnodeId, cnReference, p_out_err, '1');
2485: sDisposition:='I';
2486: nInsertCount:=nInsertCount+1;
2487: nAllocateCounter:=nAllocateCounter+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

Line 4052: UPDATE CZ_PS_NODES SET

4048: END IF;
4049:
4050: BEGIN -- bulk update
4051: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
4052: UPDATE CZ_PS_NODES SET
4053: DEVL_PROJECT_ID= DECODE(NOUPDATE_DEVL_PROJECT_ID,0,iDEVLPROJECTID(j),DEVL_PROJECT_ID),
4054: FROM_POPULATOR_ID= DECODE(NOUPDATE_FROM_POPULATOR_ID,0,iFROMPOPULATORID(j),FROM_POPULATOR_ID),
4055: PROPERTY_BACKPTR= DECODE(NOUPDATE_PROPERTY_BACKPTR,0,iPROPERTYBACKPTR(j),PROPERTY_BACKPTR),
4056: ITEM_TYPE_BACKPTR= DECODE(NOUPDATE_ITEM_TYPE_BACKPTR,0,iITEMTYPEBACKPTR(j),ITEM_TYPE_BACKPTR),

Line 4178: UPDATE CZ_PS_NODES SET

4174: END IF;
4175:
4176:
4177: BEGIN -- single row update
4178: UPDATE CZ_PS_NODES SET
4179: DEVL_PROJECT_ID= DECODE(NOUPDATE_DEVL_PROJECT_ID,0,iDEVLPROJECTID(j),DEVL_PROJECT_ID),
4180: FROM_POPULATOR_ID= DECODE(NOUPDATE_FROM_POPULATOR_ID,0,iFROMPOPULATORID(j),FROM_POPULATOR_ID),
4181: PROPERTY_BACKPTR= DECODE(NOUPDATE_PROPERTY_BACKPTR,0,iPROPERTYBACKPTR(j),PROPERTY_BACKPTR),
4182: ITEM_TYPE_BACKPTR= DECODE(NOUPDATE_ITEM_TYPE_BACKPTR,0,iITEMTYPEBACKPTR(j),ITEM_TYPE_BACKPTR),