DBA Data[Home] [Help]

APPS.EGO_CATG_MAP_PKG dependencies on EGO_CATG_MAP_DTLS

Line 382: FROM EGO_CATG_MAP_DTLS

378: l_source_catg_id NUMBER,
379: l_target_catg_id NUMBER)
380: IS
381: SELECT 1
382: FROM EGO_CATG_MAP_DTLS
383: WHERE CATG_MAP_ID = l_catg_map_id
384: AND SOURCE_CATG_ID = l_source_catg_id
385: AND TARGET_CATG_ID = l_target_catg_id
386: AND ROWNUM = 1;

Line 448: -- if it doesn't exists, inserting the data in to the ego_catg_map_dtls table

444: OPEN is_catg_map_dtls_exists(l_catg_map_id,
445: l_source_catg_id,
446: l_target_catg_id);
447:
448: -- if it doesn't exists, inserting the data in to the ego_catg_map_dtls table
449: FETCH is_catg_map_dtls_exists INTO l_count;
450: if (is_catg_map_dtls_exists%NOTFOUND) THEN
451:
452:

Line 454: INSERT INTO EGO_CATG_MAP_DTLS

450: if (is_catg_map_dtls_exists%NOTFOUND) THEN
451:
452:
453: BEGIN
454: INSERT INTO EGO_CATG_MAP_DTLS
455: (
456: CATG_MAP_ID,
457: SOURCE_CATG_ID,
458: TARGET_CATG_ID,