APPS.CZ_POPULATORS_PKG dependencies on CZ_INTL_TEXTS

Line 41: mINTL_TEXT_SEQUENCE VARCHAR2(255) := 'CZ_INTL_TEXTS_S';

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:
45: mNext_PS_Node_Id NUMBER;

Line 144: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;

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

Line 168: SELECT CZ_INTL_TEXTS_S.nextval INTO mBase_Text_Id FROM dual;

164: ELSIF p_seq_name=mINTL_TEXT_SEQUENCE THEN
165: IF (mNext_Text_Id < mBase_Text_Id+mINCREMENT-1) THEN
166: mNext_Text_Id := mNext_Text_Id + 1;
167: ELSE
168: SELECT CZ_INTL_TEXTS_S.nextval INTO mBase_Text_Id FROM dual;
169: mNext_Text_Id:=mBase_Text_Id;
170: END IF;
171: RETURN mNext_Text_Id;
172: END IF;

Line 534: var_text_str CZ_INTL_TEXTS.text_str%TYPE;

530: var_fk_key CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
531: var_instantiable_flag CZ_PS_NODES.instantiable_flag%TYPE;
532: var_minimum CZ_PS_NODES.minimum%TYPE;
533: var_maximum CZ_PS_NODES.maximum%TYPE;
534: var_text_str CZ_INTL_TEXTS.text_str%TYPE;
535: var_level NUMBER;
536: var_cursor NUMBER;
537: var_exec NUMBER;
538: var_ind NUMBER;

Line 777: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS

773: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE)=NVL(var_item_type_ptr,NULL_VALUE) AND
774: NVL(ITEM_ID,NULL_VALUE)=NVL(var_item_id,NULL_VALUE) AND
775: NVL(PS_NODE_TYPE,NULL_VALUE)=NVL(var_ps_node_type,NULL_VALUE) AND deleted_flag='0';
776:
777: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
778: WHERE intl_text_id=var_new_text_id;
779:
780: IF NVL(var_text_str,'0') <> NVL(var_desc_text,'0') THEN
781:

Line 798: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,model_id,ui_def_id,deleted_flag)

794:
795: EXCEPTION
796: WHEN NO_DATA_FOUND THEN
797: var_new_text_id := get_Next_Seq_Id(mINTL_TEXT_SEQUENCE);
798: INSERT INTO CZ_INTL_TEXTS(intl_text_id,text_str,model_id,ui_def_id,deleted_flag)
799: VALUES(var_new_text_id,var_desc_text,var_project_id,NULL,'0');
800: END;
801:
802: var_key:=TO_CHAR(NVL(var_property_ptr,NULL_VALUE))||':'||