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_CTX_TLP

Line 137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';

133: IS
134: v_sql varchar2(255);
135: BEGIN
136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:

Line 138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');

134: v_sql varchar2(255);
135: BEGIN
136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;

Line 140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');

136: --Debugging added icx_por_ext_utl.debug
137: v_sql := 'truncate table '|| ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_items_ctx_tlp';
138: icx_por_ext_utl.debug('populateDescAll, about to truncate icx_cat_items_ctx_tlp');
139: EXECUTE IMMEDIATE v_sql;
140: icx_por_ext_utl.debug('populateDescAll, icx_cat_items_ctx_tlp truncated ');
141:
142: ICX_POR_INTERMEDIA_INDEX.drop_index;
143: icx_por_ext_utl.debug('populateDescAll, drop_index done ');
144:

Line 172: ** 3. Update ctx_ in icx_cat_items_ctx_tlp with 2 .

168: ** Synopsis : Update the ctx_ for all the items in a given job.
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:

Line 489: -- delete exisiting rows from icx_cat_items_ctx_tlp

485: END IF;
486:
487: xErrLoc := 300;
488:
489: -- delete exisiting rows from icx_cat_items_ctx_tlp
490: IF (pDeleteYN = 'Y') THEN
491: FORALL i in 1..vItemIdTab.COUNT
492: DELETE FROM icx_cat_items_ctx_tlp
493: WHERE rt_item_id = vItemIdTab(i)

Line 492: DELETE FROM icx_cat_items_ctx_tlp

488:
489: -- delete exisiting rows from icx_cat_items_ctx_tlp
490: IF (pDeleteYN = 'Y') THEN
491: FORALL i in 1..vItemIdTab.COUNT
492: DELETE FROM icx_cat_items_ctx_tlp
493: WHERE rt_item_id = vItemIdTab(i)
494: AND language = vLangTab(i)
495: AND (sequence < 5000 OR sequence = 10000 OR sequence = 15000);
496: END IF;

Line 669: DELETE FROM icx_cat_items_ctx_tlp

665: xErrLoc := xErrLoc + 10;
666: -- dbms_sql.column_value will keep incrementing the indexes of the
667: -- pl/sql tables, so need to use FIRST..LAST instead of 1..COUNT
668: FORALL i IN vCItemIdTab.FIRST..vCItemIdTab.LAST
669: DELETE FROM icx_cat_items_ctx_tlp
670: WHERE rt_item_id = vCItemIdTab(i)
671: AND sequence >= 5000
672: AND sequence < 10000
673: AND language = vCLangTab(i);

Line 1081: -- delete exisiting Buyerid rows from icx_cat_items_ctx_tlp

1077: END IF;
1078:
1079: xErrLoc := 300;
1080:
1081: -- delete exisiting Buyerid rows from icx_cat_items_ctx_tlp
1082: IF (pDeleteYN = 'Y') THEN
1083: FORALL i in 1..vItemIdTab.COUNT
1084: DELETE FROM icx_cat_items_ctx_tlp
1085: WHERE rt_item_id = vItemIdTab(i)

Line 1084: DELETE FROM icx_cat_items_ctx_tlp

1080:
1081: -- delete exisiting Buyerid rows from icx_cat_items_ctx_tlp
1082: IF (pDeleteYN = 'Y') THEN
1083: FORALL i in 1..vItemIdTab.COUNT
1084: DELETE FROM icx_cat_items_ctx_tlp
1085: WHERE rt_item_id = vItemIdTab(i)
1086: AND language = vLangTab(i)
1087: AND sequence > 10000
1088: AND sequence < 15000;

Line 1094: INSERT INTO icx_cat_items_ctx_tlp

1090:
1091: IF (pSourceType = 'ROWID') THEN
1092:
1093: FORALL i IN 1..vRowIdTab.COUNT
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,

Line 1106: INSERT INTO icx_cat_items_ctx_tlp

1102: WHERE tl.rowid = vRowIdTab(i);
1103: ELSE
1104:
1105: FORALL i IN 1..vItemIdTab.COUNT
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,