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

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 198: FROM mtl_category_sets

194:
195: BEGIN
196: SELECT category_set_ID, structure_id
197: INTO l_category_set_id, l_structure_id
198: FROM mtl_category_sets
199: WHERE Category_Set_Name ='STATISTICAL_CODE';
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: l_category_set_id := NULL;

Line 207: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

203: END;
204:
205: IF l_category_set_id IS NULL THEN
206:
207: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
208: -- Assuming Master Organization Control level
209: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
210:
211: MTL_CATEGORY_SETS_PKG.INSERT_ROW (

Line 211: MTL_CATEGORY_SETS_PKG.INSERT_ROW (

207: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
208: -- Assuming Master Organization Control level
209: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
210:
211: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
212: X_ROWID => l_row_id,
213: X_CATEGORY_SET_ID => l_next_val,
214: X_CATEGORY_SET_NAME => 'STATISTICAL_CODE',
215: X_DESCRIPTION => 'Statistical Code',

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 388: FROM mtl_category_sets

384:
385: BEGIN
386: SELECT category_set_ID, structure_id
387: INTO l_category_set_id, l_structure_id
388: FROM mtl_category_sets
389: WHERE Category_Set_Name = p_category_set_name;
390: EXCEPTION
391: WHEN NO_DATA_FOUND THEN
392: l_category_set_id := NULL;

Line 396: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;

392: l_category_set_id := NULL;
393: END;
394:
395: IF l_category_set_id IS NULL THEN
396: SELECT MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
397:
398: -- Assuming Master Organization Control level
399: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
400:

Line 401: MTL_CATEGORY_SETS_PKG.INSERT_ROW (

397:
398: -- Assuming Master Organization Control level
399: -- Bug 6441455, X_CONTROL_LEVEL - Passing 2 for Org control
400:
401: MTL_CATEGORY_SETS_PKG.INSERT_ROW (
402: X_ROWID => l_row_id,
403: X_CATEGORY_SET_ID => l_next_val,
404: X_CATEGORY_SET_NAME => p_category_set_name,
405: X_DESCRIPTION => p_category_set_desc,

Line 455: update MTL_CATEGORY_SETS_TL MS set (

451: l_context :='JL.AR.APXINWKB.INVOICES';
452: l_global_att := 'GLOBAL_ATTRIBUTE10';
453: END IF;
454:
455: update MTL_CATEGORY_SETS_TL MS set (
456: SOURCE_LANG ,
457: LANGUAGE ,
458: CATEGORY_SET_NAME ,
459: DESCRIPTION ,

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 521: FROM mtl_category_sets

517: /* Get the Seeded Item Category Set Value */
518: BEGIN
519: SELECT Category_set_ID, structure_id
520: INTO p_category_set, p_structure_id
521: FROM mtl_category_sets
522: WHERE Category_Set_Name =l_category_name;
523:
524: l_category_set_exists :=TRUE;
525: l_category_status :='EXISTS';

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 644: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

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;
647: l_record_type zx_Fc_types_b.record_type_code%type;
648:

Line 1071: FROM mtl_category_sets

1067: PROCEDURE FC_ENTITIES IS
1068:
1069: CURSOR c_wine_category IS
1070: SELECT Category_set_ID
1071: FROM mtl_category_sets
1072: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
1073:
1074: l_LANGUAGE zx_fc_types_tl.language%type;
1075: l_fc_id zx_fc_codes_b.classification_id%type;

Line 1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;

1072: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
1073:
1074: l_LANGUAGE zx_fc_types_tl.language%type;
1075: l_fc_id zx_fc_codes_b.classification_id%type;
1076: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;

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 3494: FROM mtl_category_sets_vl

3490: If Zx_Migrate_Util.IS_INSTALLED('INV') = 'Y' THEN
3491:
3492: SELECT category_set_id
3493: Into l_category_set
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',

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 4560: FROM mtl_category_sets

4556: 'WINE_CIGARRETE_CATEGORY',
4557: 'Wine Cigarrete');
4558: BEGIN
4559: SELECT Category_set_ID INTO x_category_set
4560: FROM mtl_category_sets
4561: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
4562: EXCEPTION
4563: WHEN NO_DATA_FOUND THEN
4564: x_category_set := NULL;

Line 4575: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL

4571:
4572: END IF;
4573:
4574: IF x_category_set is not null then
4575: SELECT category_set_name INTO x_category_set_name FROM MTL_CATEGORY_SETS_VL
4576: WHERE category_set_id = x_category_set and rownum = 1;
4577: END IF;
4578:
4579: -- Update the record type, created by and last updated by values

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 4604: l_Inventory_Category_Set mtl_category_sets_vl.Category_set_ID%TYPE;

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;
4608: l_classification_name fnd_lookup_values.meaning%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: