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.EGO_ICC_BULKLOAD_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 4535: FROM EGO_MTL_CATALOG_GRP_VERS_B b

4531:
4532: CURSOR cur_icc_ver
4533: IS
4534: SELECT 1
4535: FROM EGO_MTL_CATALOG_GRP_VERS_B b
4536: WHERE b.item_catalog_group_id = p_icc_id
4537: AND version_seq_id <> 0;
4538:
4539: l_exists BOOLEAN := FALSE;

Line 4570: FROM EGO_MTL_CATALOG_GRP_VERS_B b

4566:
4567: CURSOR cur_icc_ver
4568: IS
4569: SELECT 1
4570: FROM EGO_MTL_CATALOG_GRP_VERS_B b
4571: WHERE b.item_catalog_group_id = p_icc_id
4572: AND p_date BETWEEN start_active_date
4573: AND NVL(end_active_date, p_date+1)
4574: AND version_seq_id <> 0;

Line 4605: FROM EGO_MTL_CATALOG_GRP_VERS_B b

4601:
4602: CURSOR cur_icc_ver
4603: IS
4604: SELECT 1
4605: FROM EGO_MTL_CATALOG_GRP_VERS_B b
4606: WHERE b.item_catalog_group_id = p_icc_id
4607: AND version_seq_id <> 0;
4608:
4609: l_exists BOOLEAN := FALSE;

Line 5280: FROM ego_mtl_catalog_grp_vers_b

5276: --- Check if version with the curr. start date already exists in
5277: --- the system
5278: ---
5279: FOR rec_dt_chk in ( SELECT 1
5280: FROM ego_mtl_catalog_grp_vers_b
5281: WHERE version_seq_id <> 0
5282: AND start_active_date = p_icc_ver_rec.start_date
5283: AND item_catalog_group_id = p_icc_ver_rec.item_catalog_group_id
5284: ) LOOP

Line 5445: INSERT INTO EGO_MTL_CATALOG_GRP_VERS_B

5441: FND_MESSAGE.SET_NAME(G_APPL_NAME,l_msg_name );
5442: l_msg_text := FND_MESSAGE.GET;
5443: l_sysdate := SYSDATE;
5444:
5445: INSERT INTO EGO_MTL_CATALOG_GRP_VERS_B
5446: (item_catalog_group_id,
5447: version_seq_id,
5448: version_description,
5449: start_active_date,

Line 7605: l_ret ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;

7601: -- Get Latest Version.
7602: --
7603: FUNCTION get_latest_version(p_item_catalog_group_id IN NUMBER) RETURN NUMBER IS
7604:
7605: l_ret ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
7606:
7607: CURSOR c IS
7608: SELECT version_seq_id
7609: FROM (

Line 7611: FROM ego_mtl_catalog_grp_vers_b ver

7607: CURSOR c IS
7608: SELECT version_seq_id
7609: FROM (
7610: SELECT version_seq_id
7611: FROM ego_mtl_catalog_grp_vers_b ver
7612: WHERE ver.item_catalog_group_id = p_item_catalog_group_id
7613: ORDER BY ver.version_seq_id DESC
7614: )
7615: WHERE ROWNUM = 1;

Line 7824: l_latest_version ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;

7820: FUNCTION change_exists(p_item_catalog_group_id IN NUMBER,
7821: p_version_seq_id IN NUMBER,
7822: p_set_process_id IN NUMBER) RETURN BOOLEAN IS
7823:
7824: l_latest_version ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
7825: l_ta_records t_ta_records;
7826: l_ta_intf_records t_ta_intf_records;
7827: l_ret BOOLEAN;
7828: l_proc_name CONSTANT VARCHAR2(30) := 'change_exists';

Line 7912: from EGO_MTL_CATALOG_GRP_VERS_B

7908: BEGIN
7909:
7910: select max(version_seq_id)
7911: into l_ver_id
7912: from EGO_MTL_CATALOG_GRP_VERS_B
7913: where item_catalog_group_id = p_icc_vers_rec.item_catalog_group_id
7914: ;
7915:
7916: return l_ver_id;

Line 7929: from EGO_MTL_CATALOG_GRP_VERS_B

7925: BEGIN
7926:
7927: select COUNT(1)
7928: into l_count
7929: from EGO_MTL_CATALOG_GRP_VERS_B
7930: where item_catalog_group_id = p_icc_vers_rec.item_catalog_group_id
7931: ;
7932:
7933: IF l_count > 0 THEN

Line 7950: FROM EGO_MTL_CATALOG_GRP_VERS_B

7946: BEGIN
7947:
7948: SELECT max(start_active_date)
7949: INTO l_date
7950: FROM EGO_MTL_CATALOG_GRP_VERS_B
7951: WHERE item_catalog_group_id = p_icc_vers_rec.item_catalog_group_id
7952: AND version_seq_id <> 0
7953: ;
7954: RETURN l_date;

Line 7990: INSERT into EGO_MTL_CATALOG_GRP_VERS_B

7986: ---
7987: l_max_seq_id := Get_Max_Sequence;
7988: --- max seq id is incremented during insert below.
7989:
7990: INSERT into EGO_MTL_CATALOG_GRP_VERS_B
7991: (item_catalog_group_id,
7992: version_seq_id,
7993: version_description,
7994: start_active_date,

Line 8123: UPDATE EGO_MTL_CATALOG_GRP_VERS_B

8119: IS
8120:
8121: BEGIN
8122:
8123: UPDATE EGO_MTL_CATALOG_GRP_VERS_B
8124: set end_active_date = p_new_end_date
8125: , last_updated_by = G_USER_ID
8126: , last_update_date = SYSDATE
8127: , last_update_login = G_LOGIN_ID

Line 8147: FROM EGO_MTL_CATALOG_GRP_VERS_B

8143:
8144: CURSOR cur_fetch_date
8145: IS
8146: SELECT min(start_active_date) min_higher_date
8147: FROM EGO_MTL_CATALOG_GRP_VERS_B
8148: WHERE item_catalog_group_id = p_icc_vers_rec.item_catalog_group_id
8149: AND start_active_date > p_date
8150: --AND p_date < nvl(end_active_date, p_date - 1)
8151: AND version_seq_id <> 0

Line 8175: FROM EGO_MTL_CATALOG_GRP_VERS_B

8171:
8172: CURSOR cur_fetch_date
8173: IS
8174: SELECT max(start_active_date) max_lower_date
8175: FROM EGO_MTL_CATALOG_GRP_VERS_B
8176: WHERE item_catalog_group_id = p_icc_vers_rec.item_catalog_group_id
8177: AND start_active_date < p_date
8178: AND version_seq_id <> 0
8179: ;