eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_POR_CTX_DESC dependencies on ICX_CAT_ITEMS_TLP

Line 30: FROM icx_cat_items_tlp tl

26: populateDescAll(p_log_type);
27: ELSE
28: OPEN items_tl_cv for
29: SELECT tl.rowid, tl.rt_item_id, tl.language
30: FROM icx_cat_items_tlp tl
31: WHERE tl.request_id = p_jobno;
32:
33: xErrLoc := 300;
34: populateCtxDescBaseAtt(items_tl_cv,'Y', 'Y', NULL, 'ROWID', 'CONCURRENT');

Line 41: FROM icx_cat_items_tlp tl

37:
38: xErrLoc := 350;
39: OPEN items_tl_cv for
40: SELECT tl.rowid, tl.rt_item_id, tl.language
41: FROM icx_cat_items_tlp tl
42: WHERE tl.request_id = p_jobno;
43:
44: xErrLoc := 400;
45: populateCtxDescBuyerInfo(items_tl_cv, 'Y', 'Y', null, 'ROWID', 'CONCURRENT');

Line 54: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index

50: populateCategoryAttribsByJob(p_jobno, 'N', 'N', 'CONCURRENT');
51:
52: xErrLoc := 700;
53:
54: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index
55: -- will pick up the changes. Master table index column need to be
56: -- updated in order for the detail table changes to be effective
57: OPEN items_tl_csr for
58: SELECT rowid FROM icx_cat_items_tlp

Line 58: SELECT rowid FROM icx_cat_items_tlp

54: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index
55: -- will pick up the changes. Master table index column need to be
56: -- updated in order for the detail table changes to be effective
57: OPEN items_tl_csr for
58: SELECT rowid FROM icx_cat_items_tlp
59: where request_id = p_jobno;
60:
61: xErrLoc := 720;
62:

Line 64: icx_por_ext_utl.debug('about to update icx_cat_items_tlp.ctx_desc');

60:
61: xErrLoc := 720;
62:
63: --Debugging
64: icx_por_ext_utl.debug('about to update icx_cat_items_tlp.ctx_desc');
65: xErrLoc := 730;
66: LOOP
67: FETCH items_tl_csr BULK COLLECT INTO
68: vRowids

Line 75: UPDATE ICX_CAT_ITEMS_TLP

71: EXIT WHEN vRowids.COUNT = 0;
72: xErrLoc := 750;
73:
74: FORALL i IN 1..vRowids.COUNT
75: UPDATE ICX_CAT_ITEMS_TLP
76: SET CTX_DESC = null
77: WHERE rowid = vRowids(i);
78:
79: xErrLoc := 800;

Line 90: icx_por_ext_utl.debug('done updating icx_cat_items_tlp.ctx_desc');

86:
87: END LOOP;
88: xErrLoc := 910;
89: --Debugging
90: icx_por_ext_utl.debug('done updating icx_cat_items_tlp.ctx_desc');
91: xErrLoc := 920;
92:
93: CLOSE items_tl_csr;
94:

Line 173: ** 4. Update ctx_desc in icx_cat_items_tlp with null : Bug#3329169

169: ** ActionPlan: 1. Collect root descriptors and local descriptors from
170: ** cursors defined above.
171: ** 2. Concatenate all from 1 into a 'allSelectList' and
172: ** 3. Update ctx_ in icx_cat_items_ctx_tlp with 2 .
173: ** 4. Update ctx_desc in icx_cat_items_tlp with null : Bug#3329169
174: ** -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
175: */
176:
177: PROCEDURE populateBaseAttributes(pDeleteYN IN VARCHAR2 DEFAULT 'Y',

Line 196: FROM icx_cat_items_tlp;

192: --icx_por_track_validate_job_s.log('populateBaseAttributes', p_log_type);
193:
194: OPEN getItemsTlCur FOR
195: SELECT rowid,rt_item_id,language
196: FROM icx_cat_items_tlp;
197:
198: xErrLoc := 200;
199:
200: populateCtxDescBaseAtt(getItemsTlCur, pDeleteYN, pUpdateYN, NULL, 'ROWID', p_log_type);

Line 207: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index

203: CLOSE getItemsTlCur;
204:
205: xErrLoc := 300;
206: -- Bug#3329169
207: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index
208: -- will pick up the changes. Master table index column need to be
209: -- updated in order for the detail table changes to be effective
210: OPEN items_tl_csr FOR
211: SELECT rowid FROM icx_cat_items_tlp;

Line 211: SELECT rowid FROM icx_cat_items_tlp;

207: -- Update the icx_cat_items_tlp.ctx_desc column so that rebuild index
208: -- will pick up the changes. Master table index column need to be
209: -- updated in order for the detail table changes to be effective
210: OPEN items_tl_csr FOR
211: SELECT rowid FROM icx_cat_items_tlp;
212:
213: xErrLoc := 320;
214: LOOP
215: FETCH items_tl_csr BULK COLLECT INTO

Line 222: UPDATE ICX_CAT_ITEMS_TLP

218: EXIT WHEN vRowids.COUNT = 0;
219:
220: xErrLoc := 340;
221: FORALL i IN 1..vRowids.COUNT
222: UPDATE ICX_CAT_ITEMS_TLP
223: SET CTX_DESC = null
224: WHERE rowid = vRowids(i);
225:
226: xErrLoc := 360;

Line 709: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||

705: IF(pLanguage IS NULL) THEN
706: FOR language_row IN installed_languages_cur LOOP
707: p_lang := language_row.language_code;
708:
709: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||
710: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
711: ':curr_lang = :p_lang AND language = :p_lang';
712:
713: c_handle := DBMS_SQL.OPEN_CURSOR;

Line 722: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||

718: c_status := DBMS_SQL.EXECUTE(c_handle);
719: DBMS_SQL.CLOSE_CURSOR(c_handle);
720: END LOOP;
721: ELSE
722: vSqlString := 'UPDATE icx_cat_items_tlp SET ctx_desc ' ||
723: ' = ''1'' WHERE rt_item_id = :p_item_id AND '||
724: 'language = :p_lang';
725:
726: c_handle := DBMS_SQL.OPEN_CURSOR;

Line 791: FROM ICX_CAT_ITEMS_TLP

787: -- base attributes
788: xErrLoc := 100;
789: OPEN vItemSourceCv FOR
790: SELECT rowid,rt_item_id, language
791: FROM ICX_CAT_ITEMS_TLP
792: WHERE RT_ITEM_ID= p_item_id;
793: xErrLoc := 200;
794:
795: IF (p_lang is NULL) THEN -- update item

Line 835: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_ITEMS_TLP' ||

831: IF(vCatTableExists = 1) THEN
832: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_EXT_ITEMS_TLP' ||
833: ' WHERE rt_item_id=:item_id and rt_category_id=:category_id';
834: ELSE
835: vSqlString := 'SELECT rowid,rt_item_id,language FROM ICX_CAT_ITEMS_TLP' ||
836: ' WHERE rt_item_id=:item_id';
837: END IF;
838:
839: xErrLoc := 540;

Line 1006: FROM icx_cat_items_tlp;

1002: xErrLoc := 100;
1003:
1004: OPEN getItemsTlCur FOR
1005: SELECT rowid, rt_item_id, language
1006: FROM icx_cat_items_tlp;
1007:
1008: xErrLoc := 200;
1009:
1010: populateCtxDescBuyerInfo(getItemsTlCur, pDeleteYN, pUpdateYN, null, 'ROWID', p_log_type);

Line 1098: FROM icx_cat_items_tlp tl,

1094: INSERT INTO icx_cat_items_ctx_tlp
1095: (rt_item_id,language,sequence,ctx_desc,org_id)
1096: SELECT tl.rt_item_id, tl.language, v_sequence,
1097: to_char(pll.org_id), pll.org_id
1098: FROM icx_cat_items_tlp tl,
1099: (SELECT distinct org_id FROM icx_cat_item_prices
1100: WHERE rt_item_id = vItemIdTab(i)
1101: ) pll
1102: WHERE tl.rowid = vRowIdTab(i);

Line 1110: FROM icx_cat_items_tlp tl,

1106: INSERT INTO icx_cat_items_ctx_tlp
1107: (rt_item_id,language,sequence,ctx_desc,org_id)
1108: SELECT tl.rt_item_id, tl.language, v_sequence,
1109: to_char(pll.org_id), pll.org_id
1110: FROM icx_cat_items_tlp tl,
1111: (SELECT distinct org_id FROM icx_cat_item_prices
1112: WHERE rt_item_id = vItemIdTab(i)
1113: ) pll
1114: WHERE tl.rt_item_id = vItemIdTab(i)