APPS.ICX_POR_MAP_CATEGORIES dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 40: UPDATE ICX_POR_category_data_sources

36:
37: BEGIN
38: p_status := 'Y'; --SUCCESS
39: xErrLoc := 100;
40: UPDATE ICX_POR_category_data_sources
41: SET category_key = p_destCatKey,
42: last_updated_by = p_userId,
43: last_update_date = sysdate
44: WHERE external_source_key = p_sourceCategory

Line 47: p_message := 'No: of rows updated in icx_por_category_data_sources:' ||SQL%ROWCOUNT;

43: last_update_date = sysdate
44: WHERE external_source_key = p_sourceCategory
45: AND external_source = 'Oracle';
46:
47: p_message := 'No: of rows updated in icx_por_category_data_sources:' ||SQL%ROWCOUNT;
48:
49: xErrLoc := 200;
50: --Mapping already existed only then requires the
51: --updation of icx_cat_category_items, icx_cat_ext_items_tlp and icx_cat_items_tlp

Line 204: INSERT INTO ICX_POR_category_data_sources

200:
201: else
202: xErrLoc := 1400;
203: --If there was no mapping existing then insert one.
204: INSERT INTO ICX_POR_category_data_sources
205: (external_source_key, external_source, created_by, last_updated_by, creation_date, last_update_date, category_key, last_update_login)
206: VALUES ( p_sourceCategory, 'Oracle', p_userId, p_userId, sysdate, sysdate, p_destCatKey, p_userId );
207: p_message := p_message ||'; New row inserted into icx_por_category_data_sources';
208: end if;

Line 207: p_message := p_message ||'; New row inserted into icx_por_category_data_sources';

203: --If there was no mapping existing then insert one.
204: INSERT INTO ICX_POR_category_data_sources
205: (external_source_key, external_source, created_by, last_updated_by, creation_date, last_update_date, category_key, last_update_login)
206: VALUES ( p_sourceCategory, 'Oracle', p_userId, p_userId, sysdate, sysdate, p_destCatKey, p_userId );
207: p_message := p_message ||'; New row inserted into icx_por_category_data_sources';
208: end if;
209: xErrLoc := 1500;
210: COMMIT;
211: EXCEPTION