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 147: SELECT CZ_INTL_TEXTS_S.NEXTVAL INTO mNext_Text_Id FROM dual;

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;
149: END IF;
150:
151: END Initialize_Sequence;

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

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

Line 537: var_text_str CZ_INTL_TEXTS.text_str%TYPE;

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

Line 783: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS

779: NVL(PS_NODE_TYPE,NULL_VALUE)=NVL(var_ps_node_type,NULL_VALUE) AND deleted_flag='0';
780:
781: ps_node_already_exists := TRUE; --Bug8584377
782:
783: SELECT text_str INTO var_text_str FROM CZ_INTL_TEXTS
784: WHERE intl_text_id=var_new_text_id;
785:
786: IF NVL(var_text_str,'0') <> NVL(var_desc_text,'0') THEN
787:

Line 804: --Bug8584377 Moved the insert into cz_intl_texts query to Execute_unsec procedure.

800:
801: EXCEPTION
802: WHEN NO_DATA_FOUND THEN
803: ps_node_already_exists := FALSE; --Bug8584377
804: --Bug8584377 Moved the insert into cz_intl_texts query to Execute_unsec procedure.
805: END;
806:
807: var_key:=TO_CHAR(NVL(var_property_ptr,NULL_VALUE))||':'||
808: TO_CHAR(NVL(var_item_type_ptr,NULL_VALUE))||':'||

Line 1337: INSERT INTO CZ_INTL_TEXTS(

1333: NVL(ITEM_TYPE_BACKPTR,NULL_VALUE)=NVL(i.ITEM_TYPE_BACKPTR,NULL_VALUE) AND
1334: NVL(ITEM_ID,NULL_VALUE)=NVL(i.ITEM_ID,NULL_VALUE) AND
1335: NVL(PS_NODE_TYPE,NULL_VALUE)=NVL(i.PS_NODE_TYPE,NULL_VALUE);
1336: --Bug8584377 Moved the insert code from Preview_unsec procedure.
1337: INSERT INTO CZ_INTL_TEXTS(
1338: INTL_TEXT_ID,
1339: TEXT_STR,
1340: MODEL_ID,
1341: UI_DEF_ID,