APPS.CZ_POPULATORS_PKG dependencies on CZ_PS_NODES_S

Line 40: mPS_NODE_SEQUENCE VARCHAR2(255) := 'CZ_PS_NODES_S';

36: mCOUNTER INTEGER:=0;
37:
38: FAILED_TO_LOCK_MODEL EXCEPTION;
39:
40: mPS_NODE_SEQUENCE VARCHAR2(255) := 'CZ_PS_NODES_S';
41: mINTL_TEXT_SEQUENCE VARCHAR2(255) := 'CZ_INTL_TEXTS_S';
42:
43: mINCREMENT NUMBER := 20;
44:

Line 144: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;

140:
141: Get_Seq_Increment;
142:
143: IF p_seq_name=mPS_NODE_SEQUENCE THEN
144: SELECT CZ_PS_NODES_S.NEXTVAL INTO mNext_PS_Node_Id FROM dual;
145: mBase_PS_Node_Id:=mNext_PS_Node_Id;
146: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN
147: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;
148: mBase_Text_Id := mNext_Text_Id;

Line 163: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;

159: IF p_seq_name=mPS_NODE_SEQUENCE THEN
160: IF (mNext_PS_Node_Id < mBase_PS_Node_Id+mINCREMENT-1) THEN
161: mNext_PS_Node_Id := mNext_PS_Node_Id + 1;
162: ELSE
163: SELECT CZ_PS_NODES_S.nextval INTO mBase_PS_Node_Id FROM dual;
164: mNext_PS_Node_Id:=mBase_PS_Node_Id;
165: END IF;
166: RETURN mNext_PS_Node_Id;
167: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN

Line 1116: UPDATE CZ_PS_NODES SET deleted_flag='1'

1112: --
1113: -- delete those PS Tree nodes which don't satisfy --
1114: -- a Populator condition anymore --
1115: --
1116: UPDATE CZ_PS_NODES SET deleted_flag='1'
1117: WHERE parent_id=var_parent_id
1118: AND deleted_flag='0' AND
1119: USER_STR03 NOT IN
1120: (SELECT USER_STR03

Line 1174: UPDATE CZ_PS_NODES SET deleted_flag='1'

1170: --
1171: -- delete those PS Tree nodes which don't satisfy --
1172: -- a Populator condition anymore --
1173: --
1174: UPDATE CZ_PS_NODES SET deleted_flag='1'
1175: WHERE parent_id=var_parent_id
1176: AND deleted_flag='0' AND
1177: (NVL(PROPERTY_BACKPTR,NULL_VALUE),
1178: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE),NVL(ITEM_ID,NULL_VALUE),