APPS.CZ_IMP_PS_NODE dependencies on CZ_PS_NODES_S

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

2089: to update model_ref_expl_id of rules' participants
2090:
2091: IF(nPsNodeType = cnReference)THEN
2092:
2093: UPDATE cz_ps_nodes SET deleted_flag='1' WHERE ps_node_id = nOnlPsnodeId;
2094: cz_refs.delete_Node(nOnlPsnodeId, cnReference, p_out_err, '1');
2095: sDisposition:='I';
2096: nInsertCount:=nInsertCount+1;
2097: nAllocateCounter:=nAllocateCounter+1;

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

Line 3618: UPDATE CZ_PS_NODES SET

3614: END IF;
3615:
3616: BEGIN -- bulk update
3617: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
3618: UPDATE CZ_PS_NODES SET
3619: DEVL_PROJECT_ID= DECODE(NOUPDATE_DEVL_PROJECT_ID,0,iDEVLPROJECTID(j),DEVL_PROJECT_ID),
3620: FROM_POPULATOR_ID= DECODE(NOUPDATE_FROM_POPULATOR_ID,0,iFROMPOPULATORID(j),FROM_POPULATOR_ID),
3621: PROPERTY_BACKPTR= DECODE(NOUPDATE_PROPERTY_BACKPTR,0,iPROPERTYBACKPTR(j),PROPERTY_BACKPTR),
3622: ITEM_TYPE_BACKPTR= DECODE(NOUPDATE_ITEM_TYPE_BACKPTR,0,iITEMTYPEBACKPTR(j),ITEM_TYPE_BACKPTR),

Line 3744: UPDATE CZ_PS_NODES SET

3740: END IF;
3741:
3742:
3743: BEGIN -- single row update
3744: UPDATE CZ_PS_NODES SET
3745: DEVL_PROJECT_ID= DECODE(NOUPDATE_DEVL_PROJECT_ID,0,iDEVLPROJECTID(j),DEVL_PROJECT_ID),
3746: FROM_POPULATOR_ID= DECODE(NOUPDATE_FROM_POPULATOR_ID,0,iFROMPOPULATORID(j),FROM_POPULATOR_ID),
3747: PROPERTY_BACKPTR= DECODE(NOUPDATE_PROPERTY_BACKPTR,0,iPROPERTYBACKPTR(j),PROPERTY_BACKPTR),
3748: ITEM_TYPE_BACKPTR= DECODE(NOUPDATE_ITEM_TYPE_BACKPTR,0,iITEMTYPEBACKPTR(j),ITEM_TYPE_BACKPTR),