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 ZX_FC_TYPES_B

Line 22: G_CLASSIFICATION_TYPE_ID zx_fc_types_b.classification_type_id%type;

18:
19: PROCEDURE Update_Category_Set (p_category_set_name IN VARCHAR2,
20: p_category_set_id IN NUMBER);
21:
22: G_CLASSIFICATION_TYPE_ID zx_fc_types_b.classification_type_id%type;
23: G_CLASSIFICATION_TYPE_CODE zx_fc_types_b.classification_type_code%type;
24: G_CLASSIFICATION_TYPE_NAME zx_fc_types_tl.classification_type_name%type;
25: G_CLASSIFICATION_TYP_CATEG_COD zx_fc_codes_denorm_b.classification_type_categ_code%type;
26: G_DELIMITER zx_fc_types_b.delimiter%type;

Line 23: G_CLASSIFICATION_TYPE_CODE zx_fc_types_b.classification_type_code%type;

19: PROCEDURE Update_Category_Set (p_category_set_name IN VARCHAR2,
20: p_category_set_id IN NUMBER);
21:
22: G_CLASSIFICATION_TYPE_ID zx_fc_types_b.classification_type_id%type;
23: G_CLASSIFICATION_TYPE_CODE zx_fc_types_b.classification_type_code%type;
24: G_CLASSIFICATION_TYPE_NAME zx_fc_types_tl.classification_type_name%type;
25: G_CLASSIFICATION_TYP_CATEG_COD zx_fc_codes_denorm_b.classification_type_categ_code%type;
26: G_DELIMITER zx_fc_types_b.delimiter%type;
27:

Line 26: G_DELIMITER zx_fc_types_b.delimiter%type;

22: G_CLASSIFICATION_TYPE_ID zx_fc_types_b.classification_type_id%type;
23: G_CLASSIFICATION_TYPE_CODE zx_fc_types_b.classification_type_code%type;
24: G_CLASSIFICATION_TYPE_NAME zx_fc_types_tl.classification_type_name%type;
25: G_CLASSIFICATION_TYP_CATEG_COD zx_fc_codes_denorm_b.classification_type_categ_code%type;
26: G_DELIMITER zx_fc_types_b.delimiter%type;
27:
28: TYPE NUM_TAB is table of number index by binary_integer;
29: TYPE VAR30_TAB is table of varchar2(30) index by binary_integer;
30:

Line 31: CURSOR G_C_GET_TYPES_INFO(X_CLASSIFICATION_TYPE_CODE zx_fc_types_b.CLASSIFICATION_TYPE_CODE%type) is

27:
28: TYPE NUM_TAB is table of number index by binary_integer;
29: TYPE VAR30_TAB is table of varchar2(30) index by binary_integer;
30:
31: CURSOR G_C_GET_TYPES_INFO(X_CLASSIFICATION_TYPE_CODE zx_fc_types_b.CLASSIFICATION_TYPE_CODE%type) is
32: SELECT TYPE.CLASSIFICATION_TYPE_ID,
33: TYPE.CLASSIFICATION_TYPE_CODE,
34: TYPE.CLASSIFICATION_TYPE_NAME,
35: TYPE.Classification_Type_Categ_Code,

Line 663: l_record_type zx_Fc_types_b.record_type_code%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;
663: l_record_type zx_Fc_types_b.record_type_code%type;
664: l_classification_name fnd_lookup_values.meaning%type;
665: l_lookup_code fnd_lookup_values.lookup_code%type;
666: l_meaning fnd_lookup_values.meaning%type;
667: l_language fnd_lookup_values.language%type;

Line 1871: FROM ZX_FC_TYPES_B

1867: fnd_global.user_id,
1868: SYSDATE,
1869: FND_GLOBAL.CONC_LOGIN_ID,
1870: 1
1871: FROM ZX_FC_TYPES_B
1872: WHERE
1873: classification_type_code = 'STATISTICAL_CODE'
1874: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1875: AND NOT EXISTS

Line 1911: FROM ZX_FC_TYPES_B

1907: fnd_global.user_id,
1908: SYSDATE,
1909: FND_GLOBAL.CONC_LOGIN_ID,
1910: 1
1911: FROM ZX_FC_TYPES_B
1912: WHERE
1913: classification_type_code = 'STATISTICAL_CODE'
1914: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1915: AND NOT EXISTS

Line 1951: FROM ZX_FC_TYPES_B

1947: fnd_global.user_id,
1948: SYSDATE,
1949: FND_GLOBAL.CONC_LOGIN_ID,
1950: 1
1951: FROM ZX_FC_TYPES_B
1952: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1953: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1954: AND NOT EXISTS
1955: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'AR');

Line 1990: FROM ZX_FC_TYPES_B

1986: fnd_global.user_id,
1987: SYSDATE,
1988: FND_GLOBAL.CONC_LOGIN_ID,
1989: 1
1990: FROM ZX_FC_TYPES_B
1991: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1992: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1993: AND NOT EXISTS
1994: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'BR');

Line 2026: FROM ZX_FC_TYPES_B

2022: fnd_global.user_id,
2023: SYSDATE,
2024: FND_GLOBAL.CONC_LOGIN_ID,
2025: 1
2026: FROM ZX_FC_TYPES_B
2027: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2028: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2029: AND NOT EXISTS
2030: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'CO');

Line 3108: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,

3104:
3105:
3106: /* COMMON PROCEDURE USED TO INSERT THE FC TYPES */
3107: PROCEDURE FC_TYPE_INSERT(
3108: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3109: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3110: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE
3111: ) IS
3112: BEGIN

Line 3110: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE

3106: /* COMMON PROCEDURE USED TO INSERT THE FC TYPES */
3107: PROCEDURE FC_TYPE_INSERT(
3108: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3109: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3110: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE
3111: ) IS
3112: BEGIN
3113:
3114: arp_util_tax.debug('Creating the fiscal classification types ');

Line 3119: INTO ZX_FC_TYPES_B(

3115:
3116: arp_util_tax.debug('p_classification_type_code = ' || p_classification_type_code);
3117:
3118: INSERT
3119: INTO ZX_FC_TYPES_B(
3120: classification_type_id,
3121: classification_type_code,
3122: classification_type_categ_code,
3123: effective_from,

Line 3138: zx_fc_types_b_s.nextval,

3134: last_update_date,
3135: last_update_login,
3136: object_version_number)
3137: (SELECT
3138: zx_fc_types_b_s.nextval,
3139: p_classification_type_code,
3140: 'PRODUCT_FISCAL_CLASS',
3141: sysdate,
3142: null,

Line 3157: (SELECT null from ZX_FC_TYPES_B

3153: FND_GLOBAL.CONC_LOGIN_ID,
3154: 1
3155: FROM dual
3156: WHERE NOT EXISTS
3157: (SELECT null from ZX_FC_TYPES_B
3158: WHERE classification_type_code = p_classification_type_code
3159: and classification_type_categ_code = 'PRODUCT_FISCAL_CLASS')
3160: );
3161:

Line 3189: ZX_FC_TYPES_B Types

3185: language_code,
3186: userenv('LANG')
3187:
3188: FROM FND_LANGUAGES L,
3189: ZX_FC_TYPES_B Types
3190: where
3191: Types.classification_type_code = p_classification_type_code
3192: and Types.classification_type_categ_code = 'PRODUCT_FISCAL_CLASS'
3193: --and Types.record_type_code = 'MIGRATED'

Line 3299: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,

3295:
3296: END FC_TYPE_INSERT;
3297:
3298: PROCEDURE FC_PARTY_TYPE_INSERT(
3299: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3300: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3301: p_tca_class IN VARCHAR2) IS
3302:
3303: BEGIN

Line 3311: INTO ZX_FC_TYPES_B(

3307:
3308: arp_util_tax.debug('p_classification_type_code = ' || p_classification_type_code);
3309:
3310: INSERT
3311: INTO ZX_FC_TYPES_B(
3312: classification_type_id,
3313: classification_type_code,
3314: classification_type_categ_code,
3315: effective_from,

Line 3330: zx_fc_types_b_s.nextval,

3326: last_update_date,
3327: last_update_login,
3328: object_version_number)
3329: (SELECT
3330: zx_fc_types_b_s.nextval,
3331: p_classification_type_code,
3332: 'PARTY_FISCAL_CLASS',
3333: sysdate,
3334: null,

Line 3349: (SELECT null from ZX_FC_TYPES_B

3345: FND_GLOBAL.CONC_LOGIN_ID,
3346: 1
3347: FROM dual
3348: WHERE NOT EXISTS
3349: (SELECT null from ZX_FC_TYPES_B
3350: WHERE classification_type_code = p_classification_type_code
3351: and classification_type_categ_code = 'PARTY_FISCAL_CLASS')
3352: );
3353:

Line 3381: ZX_FC_TYPES_B Types

3377: language_code,
3378: userenv('LANG')
3379:
3380: FROM FND_LANGUAGES L,
3381: ZX_FC_TYPES_B Types
3382: where
3383: Types.classification_type_code = p_classification_type_code
3384: and Types.classification_type_categ_code = 'PARTY_FISCAL_CLASS'
3385: --and Types.record_type_code = 'MIGRATED'

Line 3696: UPDATE ZX_FC_TYPES_B

3692: Into l_category_set
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,

Line 4804: UPDATE ZX_FC_TYPES_B SET record_type_code = 'SEEDED', created_by = 120,

4800: WHERE category_set_id = x_category_set and rownum = 1;
4801: END IF;
4802:
4803: -- Update the record type, created by and last updated by values
4804: UPDATE ZX_FC_TYPES_B SET record_type_code = 'SEEDED', created_by = 120,
4805: last_updated_by = 120, last_update_login = 0
4806: WHERE classification_type_code in ('STATISTICAL_CODE', 'FISCAL_CLASSIFICATION', 'WINE CIGARETTE') and
4807: classification_type_categ_code = 'PRODUCT_FISCAL_CLASS';
4808:

Line 4831: l_record_type zx_Fc_types_b.record_type_code%type;

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;
4832: l_classification_name fnd_lookup_values.meaning%type;
4833: l_lookup_code fnd_lookup_values.lookup_code%type;
4834: l_meaning fnd_lookup_values.meaning%type;
4835: l_language fnd_lookup_values.language%type;