DBA Data[Home] [Help]

APPS.EGO_ITEM_CATALOG_PUB dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 461: FROM ego_mtl_catalog_grp_vers_b

457: -- Checks for any active version of PARENT ICC passed as parameter.
458: cursor icc_with_active_ver (parent_icc_id VARCHAR2)
459: IS
460: SELECT version_seq_id
461: FROM ego_mtl_catalog_grp_vers_b
462: WHERE item_catalog_group_id = parent_icc_id
463: AND version_seq_id > 0
464: AND start_active_date <= SYSDATE;
465:

Line 533: insert into EGO_MTL_CATALOG_GRP_VERS_B

529: language_code = USERENV('LANG') ;
530:
531: -- dbms_output.put_line ('draft text: '||draft_str);
532:
533: insert into EGO_MTL_CATALOG_GRP_VERS_B
534: (item_catalog_group_id,
535: version_seq_id,
536: version_description,
537: start_active_date,