APPS.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_POR_CTX_DESC

Line 41: items_tl_cv ICX_POR_CTX_DESC.Item_Source_cv_Type;

37: rebuildBase NUMBER :=0;
38: vCategoryId NUMBER;
39: vItemSourceCursor NUMBER;
40: vSqlString VARCHAR2(4000);
41: items_tl_cv ICX_POR_CTX_DESC.Item_Source_cv_Type;
42:
43: CURSOR CatIdCur(p_request_id IN NUMBER) is
44: SELECT distinct catid
45: FROM (

Line 88: ICX_POR_CTX_DESC.populateBaseAttributes('Y','Y');

84: END;
85:
86: if (rebuildBase = 1) then
87: xErrLoc := 120;
88: ICX_POR_CTX_DESC.populateBaseAttributes('Y','Y');
89: xErrLoc := 130;
90: else
91: xErrLoc := 150;
92: -- no need to do the following for changed category names

Line 107: ICX_POR_CTX_DESC.populateCtxDescBaseAtt(items_tl_cv,'Y','Y',NULL,'ROWID');

103: AND ctl.rebuild_flag in ('C','B')
104: AND ctl.rt_category_id<>0;
105:
106: xErrLoc := 200;
107: ICX_POR_CTX_DESC.populateCtxDescBaseAtt(items_tl_cv,'Y','Y',NULL,'ROWID');
108:
109: xErrLoc := 300;
110: CLOSE items_tl_cv;
111: end if; --if (rebuildBase = 1)

Line 147: ICX_POR_CTX_DESC.populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,'Y',

143: END IF;
144: */
145:
146: xErrLoc := 540;
147: ICX_POR_CTX_DESC.populateCtxDescCatAtt(vCategoryId, vItemSourceCursor,'Y',
148: 'Y', NULL, 'ROWID');
149: xErrLoc:=560;
150: DBMS_SQL.CLOSE_CURSOR(vItemSourceCursor);
151: xErrLoc:=580;