APPS.ENG_CHANGE_TEXT_UTIL dependencies on ENG_CHANGE_IMTEXT_TL

Line 13: g_Index_Name VARCHAR2(30) := 'ENG_CHANGE_IMTEXT_TL_CTX1';

9:
10: g_Prod_Short_Name CONSTANT VARCHAR2(30) := 'ENG';
11: g_Prod_Schema VARCHAR2(30);
12: g_Index_Owner VARCHAR2(30);
13: g_Index_Name VARCHAR2(30) := 'ENG_CHANGE_IMTEXT_TL_CTX1';
14: g_Indexing_Context VARCHAR2(30) := 'SYNC_INDEX';
15:
16: g_installed BOOLEAN;
17: g_inst_status VARCHAR2(1);

Line 216: ENG_CHANGE_IMTEXT_TL eitl

212: , l_change_notice
213: , l_language
214: , l_text
215: FROM
216: ENG_CHANGE_IMTEXT_TL eitl
217: , ENG_ENGINEERING_CHANGES eec
218: WHERE
219: eitl.rowid = p_rowid
220: and eitl.change_id = eec.change_id

Line 325: , 'ENG_CHANGE_IMTEXT_TL'

321: (
322: mtl_system_items_interface_s.NEXTVAL
323: , p_change_id
324: , p_org_id
325: , 'ENG_CHANGE_IMTEXT_TL'
326: , p_msg_name
327: , SUBSTRB(p_error_text, 1,240)
328: , l_sysdate
329: , 1

Line 504: FROM ENG_CHANGE_IMTEXT_TL

500: temp VARCHAR2(500);
501: l_text VARCHAR2(1);
502: cursor EEC_REC is
503: SELECT change_id, text
504: FROM ENG_CHANGE_IMTEXT_TL
505: WHERE
506: change_id = p_change_id;
507: BEGIN
508: OPEN EEC_REC;

Line 512: UPDATE ENG_CHANGE_IMTEXT_TL SET TEXT = DECODE(l_text,'1','0','1') WHERE change_id = l_change_id;

508: OPEN EEC_REC;
509: LOOP
510: FETCH EEC_REC INTO l_change_id,l_text;
511: EXIT WHEN EEC_REC%NOTFOUND;
512: UPDATE ENG_CHANGE_IMTEXT_TL SET TEXT = DECODE(l_text,'1','0','1') WHERE change_id = l_change_id;
513: -- debug ( p_change_id , 0471 , 'update','updated ' || l_text );
514: END LOOP;
515:
516: IF ( EEC_REC%ROWCOUNT = 0 ) THEN

Line 518: INSERT INTO ENG_CHANGE_IMTEXT_TL

514: END LOOP;
515:
516: IF ( EEC_REC%ROWCOUNT = 0 ) THEN
517: -- debug ( p_change_id , 0471 , 'create','created ' || l_text );
518: INSERT INTO ENG_CHANGE_IMTEXT_TL
519: (
520: CHANGE_ID ,
521: LANGUAGE ,
522: TEXT ,