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.ZX_FC_MIGRATE_PKG dependencies on MTL_CATEGORY_SETS_B

Line 55: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

51:
52:
53: Procedure Create_Category_Sets IS
54:
55: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
56: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
57: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
58: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
59: l_segment FND_FLEX_KEY_API.segment_type;

Line 66: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

62: l_structure_exists Boolean;
63: l_segment_exists Boolean;
64: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
65: msg VARCHAR2(1000);
66: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
67:
68: l_structure_id NUMBER;
69: l_control_level NUMBER;
70: l_row_id VARCHAR2(100);

Line 245: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

241: p_category_set_name IN VARCHAR2,
242: p_category_set_desc IN VARCHAR2 )
243: IS
244:
245: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
246: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
247: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
248: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
249: l_segment FND_FLEX_KEY_API.segment_type;

Line 256: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

252: l_structure_exists Boolean;
253: l_segment_exists Boolean;
254: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
255: msg VARCHAR2(1000);
256: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
257:
258: l_structure_id NUMBER;
259: l_control_level NUMBER;
260: l_row_id VARCHAR2(100);

Line 527: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,

523: PROCEDURE CREATE_MTL_CATEGORIES (
524: l_lookup_type IN VARCHAR2,
525: l_category_name IN VARCHAR2,
526: l_category_status OUT NOCOPY VARCHAR2,
527: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
528: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
529: IS
530: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
531: p_structure_id mtl_category_sets_b.structure_id%TYPE;

Line 528: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )

524: l_lookup_type IN VARCHAR2,
525: l_category_name IN VARCHAR2,
526: l_category_status OUT NOCOPY VARCHAR2,
527: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
528: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
529: IS
530: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
531: p_structure_id mtl_category_sets_b.structure_id%TYPE;
532: l_category_set_exists BOOLEAN;

Line 530: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;

526: l_category_status OUT NOCOPY VARCHAR2,
527: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
528: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
529: IS
530: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
531: p_structure_id mtl_category_sets_b.structure_id%TYPE;
532: l_category_set_exists BOOLEAN;
533:
534: BEGIN

Line 531: p_structure_id mtl_category_sets_b.structure_id%TYPE;

527: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
528: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
529: IS
530: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
531: p_structure_id mtl_category_sets_b.structure_id%TYPE;
532: l_category_set_exists BOOLEAN;
533:
534: BEGIN
535:

Line 656: l_structure_id mtl_category_sets_b.structure_id%TYPE;

652: PROCEDURE MTL_SYSTEM_ITEMS IS
653:
654: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
655:
656: l_structure_id mtl_category_sets_b.structure_id%TYPE;
657: l_category_status VARCHAR2(200);
658: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
659:
660: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

Line 658: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

654: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
655:
656: l_structure_id mtl_category_sets_b.structure_id%TYPE;
657: l_category_status VARCHAR2(200);
658: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
659:
660: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
661: l_Item_id Number;
662: l_Item_organization_id Number;

Line 3144: 'MTL_CATEGORY_SETS_B',

3140: 'PRODUCT_FISCAL_CLASS',
3141: sysdate,
3142: null,
3143: 1,
3144: 'MTL_CATEGORY_SETS_B',
3145: p_owner_id_num,
3146: 1,
3147: 400,
3148: 'MIGRATED',

Line 3494: l_structure_id mtl_category_sets_b.structure_id%TYPE;

3490: PROCEDURE ZX_MIGRATE_AP IS
3491:
3492: l_fc_id zx_fc_codes_b.classification_id%type;
3493:
3494: l_structure_id mtl_category_sets_b.structure_id%TYPE;
3495: l_category_status VARCHAR2(200);
3496: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
3497:
3498: BEGIN

Line 3496: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

3492: l_fc_id zx_fc_codes_b.classification_id%type;
3493:
3494: l_structure_id mtl_category_sets_b.structure_id%TYPE;
3495: l_category_status VARCHAR2(200);
3496: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
3497:
3498: BEGIN
3499:
3500: arp_util_tax.debug('ZX_MIGRATE_AP(+)');

Line 3697: SET owner_table_code = 'MTL_CATEGORY_SETS_B',

3693: FROM mtl_category_sets_vl
3694: WHERE category_set_name ='INTENDED_USE';
3695:
3696: UPDATE ZX_FC_TYPES_B
3697: SET owner_table_code = 'MTL_CATEGORY_SETS_B',
3698: owner_id_num = l_category_set,
3699: start_position = 1,
3700: num_characters = 400,
3701: last_update_date = sysdate,

Line 4739: l_structure_id mtl_category_sets_b.structure_id%TYPE;

4735: x_return_status OUT NOCOPY VARCHAR2
4736: )
4737: IS
4738:
4739: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4740: l_category_status varchar2(200);
4741:
4742: BEGIN
4743:

Line 4825: l_structure_id mtl_category_sets_b.structure_id%TYPE;

4821:
4822:
4823: PROCEDURE OKL_MIGRATION IS
4824: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4825: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4826: l_category_status VARCHAR2(200);
4827: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4828: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4829: l_Item_id Number;

Line 4827: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

4823: PROCEDURE OKL_MIGRATION IS
4824: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4825: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4826: l_category_status VARCHAR2(200);
4827: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4828: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4829: l_Item_id Number;
4830: l_Item_organization_id Number;
4831: l_record_type zx_Fc_types_b.record_type_code%type;

Line 4844: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

4840: l_return_status varchar2(200);
4841: -- l_errorcode number;
4842: -- l_msg_count number;
4843: -- l_MSG_DATA varchar2(200);
4844: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4845: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4846: l_segment FND_FLEX_KEY_API.segment_type;
4847: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4848: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;

Line 4854: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

4850: l_structure_exists Boolean;
4851: l_segment_exists Boolean;
4852: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
4853: msg VARCHAR2(1000);
4854: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
4855: -- l_control_level NUMBER;
4856: -- l_row_id VARCHAR2(100);
4857: -- l_next_val NUMBER;
4858: