APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_DETERMINING_FACTORS_B

Line 3173: INSERT INTO ZX_DETERMINING_FACTORS_B (

3169: );
3170:
3171: -- Insert records into Determining Factors table
3172:
3173: INSERT INTO ZX_DETERMINING_FACTORS_B (
3174: DETERMINING_FACTOR_ID,
3175: DETERMINING_FACTOR_CODE,
3176: DETERMINING_FACTOR_CLASS_CODE,
3177: VALUE_SET,

Line 3197: (SELECT Zx_Determining_Factors_B_S.nextval,

3193: LAST_UPDATED_BY,
3194: LAST_UPDATE_LOGIN,
3195: OBJECT_VERSION_NUMBER)
3196:
3197: (SELECT Zx_Determining_Factors_B_S.nextval,
3198: p_classification_type_code,
3199: 'PRODUCT_FISCAL_CLASS',
3200: NULL,
3201: NULL,

Line 3221: (SELECT null from ZX_DETERMINING_FACTORS_B

3217: FND_GLOBAL.CONC_LOGIN_ID,
3218: 1
3219: FROM dual
3220: WHERE NOT EXISTS
3221: (SELECT null from ZX_DETERMINING_FACTORS_B
3222: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3223: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3224: );
3225:

Line 3254: ZX_DETERMINING_FACTORS_B detFactors

3250: L.LANGUAGE_CODE,
3251: userenv('LANG')
3252:
3253: FROM FND_LANGUAGES L,
3254: ZX_DETERMINING_FACTORS_B detFactors
3255: WHERE
3256: detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3257: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'
3258: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'

Line 3367: INSERT INTO ZX_DETERMINING_FACTORS_B (

3363: );
3364:
3365: -- Insert records into Determining Factors table
3366:
3367: INSERT INTO ZX_DETERMINING_FACTORS_B (
3368: DETERMINING_FACTOR_ID,
3369: DETERMINING_FACTOR_CODE,
3370: DETERMINING_FACTOR_CLASS_CODE,
3371: VALUE_SET,

Line 3391: (SELECT Zx_Determining_Factors_B_S.nextval,

3387: LAST_UPDATED_BY,
3388: LAST_UPDATE_LOGIN,
3389: OBJECT_VERSION_NUMBER)
3390:
3391: (SELECT Zx_Determining_Factors_B_S.nextval,
3392: p_classification_type_code,
3393: 'PARTY_FISCAL_CLASS',
3394: NULL,
3395: NULL,

Line 3415: (SELECT null from ZX_DETERMINING_FACTORS_B

3411: FND_GLOBAL.CONC_LOGIN_ID,
3412: 1
3413: FROM dual
3414: WHERE NOT EXISTS
3415: (SELECT null from ZX_DETERMINING_FACTORS_B
3416: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3417: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')
3418: );
3419:

Line 3447: ZX_DETERMINING_FACTORS_B detFactors

3443: detFactors.DETERMINING_FACTOR_ID,
3444: L.LANGUAGE_CODE,
3445: userenv('LANG')
3446: FROM FND_LANGUAGES L,
3447: ZX_DETERMINING_FACTORS_B detFactors
3448: WHERE detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3449: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
3450: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3451: and l.installed_flag in ('I', 'B')

Line 4585: UPDATE ZX_DETERMINING_FACTORS_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:
4585: UPDATE ZX_DETERMINING_FACTORS_B SET record_type_code = 'SEEDED', created_by = 120,
4586: last_updated_by = 120, last_update_login = 0
4587: WHERE determining_factor_code in ('STATISTICAL_CODE', 'FISCAL_CLASSIFICATION', 'WINE CIGARETTE') and
4588: determining_factor_class_code = 'PRODUCT_FISCAL_CLASS';
4589: