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 56: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

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

Line 67: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

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

Line 246: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

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

Line 257: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

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

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

504: PROCEDURE CREATE_MTL_CATEGORIES (
505: l_lookup_type IN VARCHAR2,
506: l_category_name IN VARCHAR2,
507: l_category_status OUT NOCOPY VARCHAR2,
508: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
509: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
510: IS
511: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
512: p_structure_id mtl_category_sets_b.structure_id%TYPE;

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

505: l_lookup_type IN VARCHAR2,
506: l_category_name IN VARCHAR2,
507: l_category_status OUT NOCOPY VARCHAR2,
508: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
509: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
510: IS
511: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
512: p_structure_id mtl_category_sets_b.structure_id%TYPE;
513: l_category_set_exists BOOLEAN;

Line 511: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;

507: l_category_status OUT NOCOPY VARCHAR2,
508: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
509: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
510: IS
511: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
512: p_structure_id mtl_category_sets_b.structure_id%TYPE;
513: l_category_set_exists BOOLEAN;
514:
515: BEGIN

Line 512: p_structure_id mtl_category_sets_b.structure_id%TYPE;

508: l_category_set OUT NOCOPY mtl_category_sets_b.Category_set_ID%TYPE,
509: l_structure_id OUT NOCOPY mtl_category_sets_b.structure_id%TYPE )
510: IS
511: p_category_set MTL_CATEGORY_SETS_B.CATEGORY_SET_ID%TYPE;
512: p_structure_id mtl_category_sets_b.structure_id%TYPE;
513: l_category_set_exists BOOLEAN;
514:
515: BEGIN
516:

Line 640: l_structure_id mtl_category_sets_b.structure_id%TYPE;

636: PROCEDURE MTL_SYSTEM_ITEMS IS
637:
638: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
639:
640: l_structure_id mtl_category_sets_b.structure_id%TYPE;
641: l_category_status VARCHAR2(200);
642: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
643:
644: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

Line 642: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

638: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
639:
640: l_structure_id mtl_category_sets_b.structure_id%TYPE;
641: l_category_status VARCHAR2(200);
642: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
643:
644: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
645: l_Item_id Number;
646: l_Item_organization_id Number;

Line 3113: 'MTL_CATEGORY_SETS_B',

3109: 'PRODUCT_FISCAL_CLASS',
3110: sysdate,
3111: null,
3112: 1,
3113: 'MTL_CATEGORY_SETS_B',
3114: p_owner_id_num,
3115: 1,
3116: 400,
3117: 'MIGRATED',

Line 3467: l_structure_id mtl_category_sets_b.structure_id%TYPE;

3463: PROCEDURE ZX_MIGRATE_AP IS
3464:
3465: l_fc_id zx_fc_codes_b.classification_id%type;
3466:
3467: l_structure_id mtl_category_sets_b.structure_id%TYPE;
3468: l_category_status VARCHAR2(200);
3469: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
3470:
3471: BEGIN

Line 3469: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

3465: l_fc_id zx_fc_codes_b.classification_id%type;
3466:
3467: l_structure_id mtl_category_sets_b.structure_id%TYPE;
3468: l_category_status VARCHAR2(200);
3469: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
3470:
3471: BEGIN
3472:
3473: arp_util_tax.debug('ZX_MIGRATE_AP(+)');

Line 3498: SET owner_table_code = 'MTL_CATEGORY_SETS_B',

3494: FROM mtl_category_sets_vl
3495: WHERE category_set_name ='INTENDED_USE';
3496:
3497: UPDATE ZX_FC_TYPES_B
3498: SET owner_table_code = 'MTL_CATEGORY_SETS_B',
3499: owner_id_num = l_category_set,
3500: start_position = 1,
3501: num_characters = 400,
3502: last_update_date = sysdate,

Line 4515: l_structure_id mtl_category_sets_b.structure_id%TYPE;

4511: x_return_status OUT NOCOPY VARCHAR2
4512: )
4513: IS
4514:
4515: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4516: l_category_status varchar2(200);
4517:
4518: BEGIN
4519:

Line 4601: l_structure_id mtl_category_sets_b.structure_id%TYPE;

4597:
4598:
4599: PROCEDURE OKL_MIGRATION IS
4600: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4601: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4602: l_category_status VARCHAR2(200);
4603: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4605: l_Item_id Number;

Line 4603: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;

4599: PROCEDURE OKL_MIGRATION IS
4600: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
4601: l_structure_id mtl_category_sets_b.structure_id%TYPE;
4602: l_category_status VARCHAR2(200);
4603: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;
4605: l_Item_id Number;
4606: l_Item_organization_id Number;
4607: l_record_type zx_Fc_types_b.record_type_code%type;

Line 4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;

4616: l_return_status varchar2(200);
4617: -- l_errorcode number;
4618: -- l_msg_count number;
4619: -- l_MSG_DATA varchar2(200);
4620: p_category_set mtl_category_sets_b.Category_set_ID%TYPE;
4621: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
4622: l_segment FND_FLEX_KEY_API.segment_type;
4623: p_StatCode_Segment FND_FLEX_KEY_API.segment_type;
4624: p_StatCode_Segmentnew FND_FLEX_KEY_API.segment_type;

Line 4630: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;

4626: l_structure_exists Boolean;
4627: l_segment_exists Boolean;
4628: p_StatCode_struct FND_FLEX_KEY_API.STRUCTURE_TYPE;
4629: msg VARCHAR2(1000);
4630: l_category_set_id mtl_category_sets_b.Category_set_ID%TYPE;
4631: -- l_control_level NUMBER;
4632: -- l_row_id VARCHAR2(100);
4633: -- l_next_val NUMBER;
4634: