APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_FC_TYPES_TL

Line 24: G_CLASSIFICATION_TYPE_NAME zx_fc_types_tl.classification_type_name%type;

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:
28: TYPE NUM_TAB is table of number index by binary_integer;

Line 1074: l_LANGUAGE zx_fc_types_tl.language%type;

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;
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;

Line 3078: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,

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
3082:

Line 3133: INTO ZX_FC_TYPES_TL(

3129: );
3130:
3131:
3132: INSERT
3133: INTO ZX_FC_TYPES_TL(
3134: CLASSIFICATION_TYPE_ID,
3135: CLASSIFICATION_TYPE_NAME,
3136: CREATED_BY,
3137: CREATION_DATE,

Line 3166: (select NULL from ZX_FC_TYPES_TL T

3162: and Types.classification_type_categ_code = 'PRODUCT_FISCAL_CLASS'
3163: --and Types.record_type_code = 'MIGRATED'
3164: and l.installed_flag in ('I', 'B')
3165: and NOT EXISTS -- this condition makes sure we dont duplicate data
3166: (select NULL from ZX_FC_TYPES_TL T
3167: where T.CLASSIFICATION_TYPE_ID = Types.CLASSIFICATION_TYPE_ID
3168: and T.LANGUAGE = L.LANGUAGE_CODE)
3169: );
3170:

Line 3271: p_classification_type_name IN ZX_FC_TYPES_TL.CLASSIFICATION_TYPE_NAME%TYPE,

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
3275: -- Get the Party Classification ID

Line 3327: INTO ZX_FC_TYPES_TL(

3323: );
3324:
3325:
3326: INSERT
3327: INTO ZX_FC_TYPES_TL(
3328: CLASSIFICATION_TYPE_ID,
3329: CLASSIFICATION_TYPE_NAME,
3330: CREATED_BY,
3331: CREATION_DATE,

Line 3360: (select NULL from ZX_FC_TYPES_TL T

3356: and Types.classification_type_categ_code = 'PARTY_FISCAL_CLASS'
3357: --and Types.record_type_code = 'MIGRATED'
3358: and l.installed_flag in ('I', 'B')
3359: and NOT EXISTS -- this condition makes sure we dont duplicate data
3360: (select NULL from ZX_FC_TYPES_TL T
3361: where T.CLASSIFICATION_TYPE_ID = Types.CLASSIFICATION_TYPE_ID
3362: and T.LANGUAGE = L.LANGUAGE_CODE)
3363: );
3364: