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
33: TYPE.CLASSIFICATION_TYPE_ID,
34: TYPE.CLASSIFICATION_TYPE_CODE,
35: TYPE.CLASSIFICATION_TYPE_NAME,

Line 647: l_record_type zx_Fc_types_b.record_type_code%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:
649: l_classification_name fnd_lookup_values.meaning%type;
650:
651: l_lookup_code fnd_lookup_values.lookup_code%type;

Line 1878: FROM ZX_FC_TYPES_B

1874: fnd_global.user_id,
1875: SYSDATE,
1876: FND_GLOBAL.CONC_LOGIN_ID,
1877: 1
1878: FROM ZX_FC_TYPES_B
1879: WHERE
1880: classification_type_code = 'STATISTICAL_CODE'
1881: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1882: AND NOT EXISTS

Line 1918: FROM ZX_FC_TYPES_B

1914: fnd_global.user_id,
1915: SYSDATE,
1916: FND_GLOBAL.CONC_LOGIN_ID,
1917: 1
1918: FROM ZX_FC_TYPES_B
1919: WHERE
1920: classification_type_code = 'STATISTICAL_CODE'
1921: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1922: AND NOT EXISTS

Line 1958: FROM ZX_FC_TYPES_B

1954: fnd_global.user_id,
1955: SYSDATE,
1956: FND_GLOBAL.CONC_LOGIN_ID,
1957: 1
1958: FROM ZX_FC_TYPES_B
1959: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1960: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
1961: AND NOT EXISTS
1962: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'AR');

Line 1997: FROM ZX_FC_TYPES_B

1993: fnd_global.user_id,
1994: SYSDATE,
1995: FND_GLOBAL.CONC_LOGIN_ID,
1996: 1
1997: FROM ZX_FC_TYPES_B
1998: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
1999: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2000: AND NOT EXISTS
2001: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'BR');

Line 2033: FROM ZX_FC_TYPES_B

2029: fnd_global.user_id,
2030: SYSDATE,
2031: FND_GLOBAL.CONC_LOGIN_ID,
2032: 1
2033: FROM ZX_FC_TYPES_B
2034: WHERE classification_type_code = 'FISCAL_CLASSIFICATION'
2035: and classification_type_categ_code ='PRODUCT_FISCAL_CLASS'
2036: AND NOT EXISTS
2037: (SELECT 1 FROM ZX_FC_COUNTRY_DEFAULTS WHERE COUNTRY_CODE = 'CO');

Line 3077: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,

3073:
3074:
3075: /* COMMON PROCEDURE USED TO INSERT THE FC TYPES */
3076: PROCEDURE FC_TYPE_INSERT(
3077: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3078: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3079: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE
3080: ) IS
3081: BEGIN

Line 3079: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE

3075: /* COMMON PROCEDURE USED TO INSERT THE FC TYPES */
3076: PROCEDURE FC_TYPE_INSERT(
3077: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3078: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3079: p_owner_id_num IN ZX_FC_TYPES_B.OWNER_ID_NUM%TYPE
3080: ) IS
3081: BEGIN
3082:
3083: arp_util_tax.debug('Creating the fiscal classification types ');

Line 3088: INTO ZX_FC_TYPES_B(

3084:
3085: arp_util_tax.debug('p_classification_type_code = ' || p_classification_type_code);
3086:
3087: INSERT
3088: INTO ZX_FC_TYPES_B(
3089: classification_type_id,
3090: classification_type_code,
3091: classification_type_categ_code,
3092: effective_from,

Line 3107: zx_fc_types_b_s.nextval,

3103: last_update_date,
3104: last_update_login,
3105: object_version_number)
3106: (SELECT
3107: zx_fc_types_b_s.nextval,
3108: p_classification_type_code,
3109: 'PRODUCT_FISCAL_CLASS',
3110: sysdate,
3111: null,

Line 3126: (SELECT null from ZX_FC_TYPES_B

3122: FND_GLOBAL.CONC_LOGIN_ID,
3123: 1
3124: FROM dual
3125: WHERE NOT EXISTS
3126: (SELECT null from ZX_FC_TYPES_B
3127: WHERE classification_type_code = p_classification_type_code
3128: and classification_type_categ_code = 'PRODUCT_FISCAL_CLASS')
3129: );
3130:

Line 3159: ZX_FC_TYPES_B Types

3155: language_code,
3156: userenv('LANG')
3157:
3158: FROM FND_LANGUAGES L,
3159: ZX_FC_TYPES_B Types
3160: where
3161: Types.classification_type_code = p_classification_type_code
3162: and Types.classification_type_categ_code = 'PRODUCT_FISCAL_CLASS'
3163: --and Types.record_type_code = 'MIGRATED'

Line 3270: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,

3266:
3267: END FC_TYPE_INSERT;
3268:
3269: PROCEDURE FC_PARTY_TYPE_INSERT(
3270: p_classification_type_code IN ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE,
3271: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,
3272: p_tca_class IN VARCHAR2) IS
3273:
3274: BEGIN

Line 3282: INTO ZX_FC_TYPES_B(

3278:
3279: arp_util_tax.debug('p_classification_type_code = ' || p_classification_type_code);
3280:
3281: INSERT
3282: INTO ZX_FC_TYPES_B(
3283: classification_type_id,
3284: classification_type_code,
3285: classification_type_categ_code,
3286: effective_from,

Line 3301: zx_fc_types_b_s.nextval,

3297: last_update_date,
3298: last_update_login,
3299: object_version_number)
3300: (SELECT
3301: zx_fc_types_b_s.nextval,
3302: p_classification_type_code,
3303: 'PARTY_FISCAL_CLASS',
3304: sysdate,
3305: null,

Line 3320: (SELECT null from ZX_FC_TYPES_B

3316: FND_GLOBAL.CONC_LOGIN_ID,
3317: 1
3318: FROM dual
3319: WHERE NOT EXISTS
3320: (SELECT null from ZX_FC_TYPES_B
3321: WHERE classification_type_code = p_classification_type_code
3322: and classification_type_categ_code = 'PARTY_FISCAL_CLASS')
3323: );
3324:

Line 3353: ZX_FC_TYPES_B Types

3349: language_code,
3350: userenv('LANG')
3351:
3352: FROM FND_LANGUAGES L,
3353: ZX_FC_TYPES_B Types
3354: where
3355: Types.classification_type_code = p_classification_type_code
3356: and Types.classification_type_categ_code = 'PARTY_FISCAL_CLASS'
3357: --and Types.record_type_code = 'MIGRATED'

Line 3497: UPDATE ZX_FC_TYPES_B

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',
3499: owner_id_num = l_category_set,
3500: start_position = 1,
3501: num_characters = 400,

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

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
4580: UPDATE ZX_FC_TYPES_B SET record_type_code = 'SEEDED', created_by = 120,
4581: last_updated_by = 120, last_update_login = 0
4582: WHERE classification_type_code in ('STATISTICAL_CODE', 'FISCAL_CLASSIFICATION', 'WINE CIGARETTE') and
4583: classification_type_categ_code = 'PRODUCT_FISCAL_CLASS';
4584:

Line 4607: l_record_type zx_Fc_types_b.record_type_code%type;

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;
4609: l_lookup_code fnd_lookup_values.lookup_code%type;
4610: l_meaning fnd_lookup_values.meaning%type;
4611: l_language fnd_lookup_values.language%type;