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 MTL_ITEM_CATALOG_GROUPS_B

Line 10: g_old_icc_rec mtl_item_catalog_groups_b%rowtype;

6: g_ag_assoc_rec_count NUMBER := 0;
7: g_fn_param_map_count NUMBER := 0;
8: g_icc_vers_rec_count NUMBER := 0;
9: g_item_obj_id NUMBER := NULL;
10: g_old_icc_rec mtl_item_catalog_groups_b%rowtype;
11:
12:
13: CURSOR cur_get_obj_id
14: IS

Line 1499: FROM mtl_item_catalog_groups_b

1495: and oagv.data_level_int_name = l_item_data_level
1496: AND oagv.classification_code
1497: IN (
1498: SELECT TO_CHAR (item_catalog_group_id)
1499: FROM mtl_item_catalog_groups_b
1500: CONNECT BY PRIOR parent_catalog_group_id =
1501: item_catalog_group_id
1502: START WITH item_catalog_group_id = EFPMI.ITEM_CATALOG_GROUP_ID
1503: )

Line 1531: FROM mtl_item_catalog_groups_b

1527: and oagv.data_level_int_name = l_item_data_level
1528: AND oagv.classification_code
1529: IN (
1530: SELECT TO_CHAR (item_catalog_group_id)
1531: FROM mtl_item_catalog_groups_b
1532: CONNECT BY PRIOR parent_catalog_group_id =
1533: item_catalog_group_id
1534: START WITH item_catalog_group_id = EFPMI.ITEM_CATALOG_GROUP_ID
1535: )

Line 2310: FROM mtl_Item_Catalog_Groups_b

2306: BEGIN
2307:
2308: SELECT item_catalog_group_id
2309: INTO l_ccid
2310: FROM mtl_Item_Catalog_Groups_b
2311: WHERE item_catalog_group_id = p_catalog_grp_id;
2312:
2313: Return TRUE;
2314:

Line 2537: FROM mtl_item_catalog_groups_b cat

2533:
2534:
2535: CURSOR c IS
2536: SELECT cat.item_num_action_id, cat.item_desc_action_id
2537: FROM mtl_item_catalog_groups_b cat
2538: WHERE cat.item_catalog_group_id = p_item_catalog_group_id;
2539:
2540: BEGIN
2541: OPEN c;

Line 2593: l_num_action_id mtl_item_catalog_groups_b.item_num_action_id%TYPE;

2589: FUNCTION get_action_id (p_item_catalog_group_id IN NUMBER,
2590: p_function_id IN NUMBER,
2591: p_object_id IN NUMBER) RETURN NUMBER IS
2592:
2593: l_num_action_id mtl_item_catalog_groups_b.item_num_action_id%TYPE;
2594: l_desc_action_id mtl_item_catalog_groups_b.item_desc_action_id%TYPE;
2595: l_proc_name CONSTANT VARCHAR2(30) := 'GET_ACTION_ID';
2596: BEGIN
2597: write_debug(l_proc_name,'Entering method with params icc id = ' || p_item_catalog_group_id ||

Line 2594: l_desc_action_id mtl_item_catalog_groups_b.item_desc_action_id%TYPE;

2590: p_function_id IN NUMBER,
2591: p_object_id IN NUMBER) RETURN NUMBER IS
2592:
2593: l_num_action_id mtl_item_catalog_groups_b.item_num_action_id%TYPE;
2594: l_desc_action_id mtl_item_catalog_groups_b.item_desc_action_id%TYPE;
2595: l_proc_name CONSTANT VARCHAR2(30) := 'GET_ACTION_ID';
2596: BEGIN
2597: write_debug(l_proc_name,'Entering method with params icc id = ' || p_item_catalog_group_id ||
2598: ' function_id = ' || p_function_id ||

Line 3763: PROCEDURE Fetch_Old_ICC_Dtls ( p_old_icc_rec IN OUT NOCOPY mtl_item_catalog_groups_b%ROWTYPE

3759: --- gets the details for the earlier ICC
3760: --- for UPDATE transaction
3761: ********************************************************************/
3762:
3763: PROCEDURE Fetch_Old_ICC_Dtls ( p_old_icc_rec IN OUT NOCOPY mtl_item_catalog_groups_b%ROWTYPE
3764: ,p_icc_id IN NUMBER
3765: )
3766: IS
3767:

Line 3774: FROM mtl_item_catalog_groups_b

3770: write_debug(l_proc_name,'Start');
3771:
3772: SELECT *
3773: INTO p_old_icc_rec
3774: FROM mtl_item_catalog_groups_b
3775: WHERE item_catalog_group_id = p_icc_id;
3776:
3777: write_debug(l_proc_name,'End');
3778: END Fetch_Old_ICC_Dtls;

Line 4442: FROM mtl_item_catalog_groups_b

4438: AND cg.catalog_group_id = oagv.classification_code
4439: AND oagv.object_id = g_item_obj_id
4440: AND oagv.classification_code IN (
4441: SELECT TO_CHAR (item_catalog_group_id)
4442: FROM mtl_item_catalog_groups_b
4443: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
4444: START WITH item_catalog_group_id = p_icc_id
4445: )
4446: ;

Line 4644: l_icc_name mtl_item_catalog_groups_b_kfv.padded_concatenated_segments%TYPE := null;

4640: l_null_icc_rec_type EGO_ITEM_CATALOG_PUB.Catalog_Group_Rec_Type := null ;
4641: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4642: l_dummy boolean;
4643: l_data_level_id ego_data_level_b.data_level_id%TYPE := NULL;
4644: l_icc_name mtl_item_catalog_groups_b_kfv.padded_concatenated_segments%TYPE := null;
4645: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;
4646: l_return_status VARCHAR2(1);
4647: l_return_status2 VARCHAR2(1);
4648: l_locking_party_id NUMBER;

Line 6511: UPDATE MTL_ITEM_CATALOG_GROUPS_B

6507: x_return_status := G_RET_STS_SUCCESS;
6508: write_debug (l_proc_name, 'Start');
6509:
6510:
6511: UPDATE MTL_ITEM_CATALOG_GROUPS_B
6512: SET
6513: ITEM_NUM_ACTION_ID = decode ( p_col_name, G_NUM_GEN_FUNCTION , null, ITEM_NUM_ACTION_ID)
6514: , ITEM_DESC_ACTION_ID = decode ( p_col_name, G_DESC_GEN_FUNCTION , null, ITEM_DESC_ACTION_ID)
6515: ,last_updated_by = G_USER_ID

Line 6550: UPDATE MTL_ITEM_CATALOG_GROUPS_B

6546: x_return_status := G_RET_STS_SUCCESS;
6547: write_debug (l_proc_name, 'Start');
6548:
6549:
6550: UPDATE MTL_ITEM_CATALOG_GROUPS_B
6551: SET
6552: ITEM_NUM_GEN_METHOD = p_icc_rec.item_num_gen_method_type
6553: ,PREFIX = p_icc_rec.prefix
6554: ,STARTING_NUMBER = p_icc_rec.starting_number

Line 8496: FROM mtl_item_catalog_groups_b

8492:
8493: CURSOR cur_icc_column_chk ( p_action_id NUMBER, p_icc_id NUMBER)
8494: IS
8495: SELECT G_NUM_GEN_FUNCTION column_name
8496: FROM mtl_item_catalog_groups_b
8497: WHERE item_catalog_group_id = p_icc_id
8498: AND item_num_action_id = p_action_id
8499: UNION ALL
8500: SELECT G_DESC_GEN_FUNCTION column_name

Line 8501: FROM mtl_item_catalog_groups_b

8497: WHERE item_catalog_group_id = p_icc_id
8498: AND item_num_action_id = p_action_id
8499: UNION ALL
8500: SELECT G_DESC_GEN_FUNCTION column_name
8501: FROM mtl_item_catalog_groups_b
8502: WHERE item_catalog_group_id = p_icc_id
8503: AND item_desc_action_id = p_action_id
8504: ;
8505: