[Home] [Help]
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;
29: TYPE VAR30_TAB is table of varchar2(30) index by binary_integer;
843: SYSDATE,
844: FND_GLOBAL.CONC_LOGIN_ID,
845: LANGUAGE,
846: SOURCE_LANGUAGE)
847: INTO ZX_FC_CODES_DENORM_B(
848: CLASSIFICATION_TYPE_ID,
849: CLASSIFICATION_TYPE_CODE,
850: CLASSIFICATION_TYPE_NAME,
851: CLASSIFICATION_TYPE_CATEG_CODE,
966: AND FL.language=L.language_code(+)
967: AND L.INSTALLED_FLAG in ('I', 'B')
968: AND NOT EXISTS -- this condition makes sure we dont duplicate data
969: (select NULL
970: from ZX_FC_CODES_DENORM_B codes
971: where codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
972: and codes.classification_code = fl.lookup_code
973: and codes.ancestor_id = nvl(l_fc_id,codes.ancestor_id)
974: and codes.language = l.language_code);
1172: SYSDATE,
1173: FND_GLOBAL.CONC_LOGIN_ID,
1174: lang_code,
1175: userenv('LANG'))
1176: INTO ZX_FC_CODES_DENORM_B(
1177: CLASSIFICATION_TYPE_ID,
1178: CLASSIFICATION_TYPE_CODE,
1179: CLASSIFICATION_TYPE_NAME,
1180: CLASSIFICATION_TYPE_CATEG_CODE,
1285: AND Codes.classification_code=JLBR.cfo_code
1286: AND Codes.RECORD_TYPE_CODE = 'MIGRATED'
1287: AND L.INSTALLED_FLAG in ('I', 'B')
1288: AND NOT EXISTS -- this condition makes sure we dont duplicate data
1289: (select NULL from ZX_FC_CODES_DENORM_B codes
1290: where codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1291: and codes.classification_code = JLBR.cfo_code
1292: and codes.ancestor_id is null
1293: and codes.language = l.language_code);
1348: FND_GLOBAL.CONC_LOGIN_ID,
1349: 1
1350: FROM
1351: JL_BR_AP_OPERATIONS ap_op,
1352: ZX_FC_CODES_DENORM_B fc,
1353: ZX_EVENT_CLASSES_VL event
1354: WHERE
1355: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1356: and fc.classification_code='OPERATION FISCAL CODE'
1388: SYSDATE,
1389: FND_GLOBAL.CONC_LOGIN_ID,
1390: lang_code,
1391: userenv('LANG'))
1392: INTO ZX_FC_CODES_DENORM_B(
1393: CLASSIFICATION_TYPE_ID,
1394: CLASSIFICATION_TYPE_CODE,
1395: CLASSIFICATION_TYPE_NAME,
1396: CLASSIFICATION_TYPE_CATEG_CODE,
1498: ap_op.creation_date,
1499: codes.classification_id,
1500: l.language_code lang_code
1501: FROM
1502: ZX_FC_CODES_DENORM_B fc,
1503: ZX_FC_CODES_B Codes,
1504: JL_BR_AP_OPERATIONS ap_op,
1505: FND_LANGUAGES L,
1506: ZX_EVENT_CLASSES_VL event
1518: and Codes.RECORD_TYPE_CODE = 'MIGRATED'
1519: and L.INSTALLED_FLAG in ('I', 'B')
1520:
1521: AND NOT EXISTS -- this condition makes sure we dont duplicate data
1522: (select NULL from ZX_FC_CODES_DENORM_B codes where
1523: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1524: and codes.classification_code = ap_op.cfo_code
1525: and codes.ancestor_id = nvl(fc.classification_id,codes.ancestor_id)
1526: and codes.language = l.language_code);
1633: FND_GLOBAL.CONC_LOGIN_ID,
1634: language,
1635: source_lang)
1636:
1637: INTO ZX_FC_CODES_DENORM_B
1638: (CLASSIFICATION_TYPE_ID,
1639: CLASSIFICATION_TYPE_CODE,
1640: CLASSIFICATION_TYPE_NAME,
1641: CLASSIFICATION_TYPE_CATEG_CODE,
1755: AND LV.lookup_type='JATW_GUI_TYPE'
1756: AND LV.language=L.language_code(+)
1757: AND L.INSTALLED_FLAG in ('I', 'B')
1758: AND NOT EXISTS -- this condition makes sure we dont duplicate data
1759: (select NULL from ZX_FC_CODES_DENORM_B codes where
1760: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1761: and codes.classification_code = lv.lookup_code
1762: and codes.ancestor_id = nvl(l_fc_id,codes.ancestor_id)
1763: and codes.language = l.language_code);
2136: SYSDATE,
2137: FND_GLOBAL.CONC_LOGIN_ID,
2138: lang_code,
2139: userenv('LANG'))
2140: INTO ZX_FC_CODES_DENORM_B
2141: (CLASSIFICATION_TYPE_ID,
2142: CLASSIFICATION_TYPE_CODE,
2143: CLASSIFICATION_TYPE_NAME,
2144: CLASSIFICATION_TYPE_CATEG_CODE,
2246: and fc_codes.parent_classification_id is null
2247: and fc_codes.classification_code = p_classification_code
2248:
2249: AND NOT EXISTS -- this condition makes sure we dont duplicate data
2250: (select NULL from ZX_FC_CODES_DENORM_B CODES where
2251: codes.classification_type_code = p_classification_type_code
2252: and codes.classification_code = p_classification_code
2253: and codes.ancestor_id is null
2254: and codes.LANGUAGE = L.LANGUAGE_CODE);
2275: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2276: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2277: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2278: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2279: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2280: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
2281: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE)
2282: IS
2283:
2276: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2277: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2278: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2279: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2280: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
2281: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE)
2282: IS
2283:
2284: BEGIN
2277: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2278: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2279: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2280: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
2281: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE)
2282: IS
2283:
2284: BEGIN
2285:
2367: SYSDATE,
2368: FND_GLOBAL.CONC_LOGIN_ID,
2369: language,
2370: SOURCE_LANG)
2371: INTO ZX_FC_CODES_DENORM_B(
2372: CLASSIFICATION_TYPE_ID,
2373: CLASSIFICATION_TYPE_CODE,
2374: CLASSIFICATION_TYPE_NAME,
2375: CLASSIFICATION_TYPE_CATEG_CODE,
2494: AND fl.language=l.language_code(+)
2495: AND l.INSTALLED_FLAG in ('I', 'B')
2496:
2497: AND NOT EXISTS -- this condition makes sure we dont duplicate data
2498: (select NULL from ZX_FC_CODES_DENORM_B codes where
2499: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
2500: and codes.classification_code = fl.lookup_code
2501: and (codes.ancestor_id = p_parent_fc_id or
2502: p_parent_fc_id is null)
2583: SYSDATE,
2584: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2585: 1
2586: FROM
2587: ZX_FC_CODES_DENORM_B fc,
2588: ZX_EVENT_CLASSES_VL event,
2589: FND_LOOKUP_VALUES FL
2590: WHERE
2591: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2629: SYSDATE,
2630: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2631: language,
2632: SOURCE_LANG)
2633: INTO ZX_FC_CODES_DENORM_B(
2634: CLASSIFICATION_TYPE_ID,
2635: CLASSIFICATION_TYPE_CODE,
2636: CLASSIFICATION_TYPE_NAME,
2637: CLASSIFICATION_TYPE_CATEG_CODE,
2743: fl.enabled_flag,
2744: Codes.classification_id
2745:
2746: FROM
2747: ZX_FC_CODES_DENORM_B fc,
2748: ZX_FC_CODES_b Codes,
2749: ZX_EVENT_CLASSES_VL event,
2750: FND_LOOKUP_VALUES FL,
2751: FND_LANGUAGES L
2763: and FL.enabled_flag = 'Y'
2764: and FL.language=L.language_code(+)
2765: and L.INSTALLED_FLAG in ('I', 'B')
2766: and NOT EXISTS -- this condition makes sure we dont duplicate data
2767: ( select NULL from ZX_FC_CODES_DENORM_B codes
2768: where codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
2769: and codes.classification_code = fl.lookup_code
2770: and codes.ancestor_id = nvl(fc.classification_id,codes.ancestor_id)
2771: and codes.language = l.language_code);
2880: fnd_global.conc_login_id,
2881: lang_code,
2882: userenv('LANG'))
2883:
2884: INTO ZX_FC_CODES_DENORM_B(
2885: CLASSIFICATION_TYPE_ID,
2886: CLASSIFICATION_TYPE_CODE,
2887: CLASSIFICATION_TYPE_NAME,
2888: CLASSIFICATION_TYPE_CATEG_CODE,
3003: and (zx.RECORD_TYPE_CODE = 'MIGRATED' OR zx.RECORD_TYPE_CODE = 'SEEDED')
3004: and event.language = L.language_code(+)
3005: and L.INSTALLED_FLAG in ('I', 'B')
3006: and NOT EXISTS -- this condition makes sure we dont duplicate data
3007: ( select NULL from ZX_FC_CODES_DENORM_B codes
3008: where
3009: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
3010: and codes.classification_code = p_classification_code
3011: and codes.ancestor_id = nvl(fc.classification_id,codes.ancestor_id)
3677: SYSDATE,
3678: FND_GLOBAL.CONC_LOGIN_ID,
3679: lang_code,
3680: userenv('LANG'))
3681: INTO ZX_FC_CODES_DENORM_B
3682: (CLASSIFICATION_TYPE_ID,
3683: CLASSIFICATION_TYPE_CODE,
3684: CLASSIFICATION_TYPE_NAME,
3685: CLASSIFICATION_TYPE_CATEG_CODE,
3798: and vs.FLEX_VALUE_SET_NAME ='JE_FR_TAX_RULE'
3799: AND v.enabled_flag = 'Y'
3800: AND L.INSTALLED_FLAG in ('I', 'B')
3801: AND NOT EXISTS -- this condition makes sure we dont duplicate data
3802: (select NULL from ZX_FC_CODES_DENORM_B codes
3803: where
3804: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
3805: and codes.classification_code = v.flex_value
3806: and codes.ancestor_id = nvl(l_fc_id,codes.ancestor_id)
3899: FND_GLOBAL.CONC_LOGIN_ID,
3900: language,
3901: source_lang)
3902:
3903: INTO ZX_FC_CODES_DENORM_B
3904:
3905: (CLASSIFICATION_TYPE_ID,
3906: CLASSIFICATION_TYPE_CODE,
3907: CLASSIFICATION_TYPE_NAME,
4023: AND LV.LANGUAGE=L.LANGUAGE_CODE(+)
4024: AND L.INSTALLED_FLAG in ('I', 'B')
4025: AND NOT EXISTS -- this condition makes sure we dont duplicate data
4026: (select NULL
4027: from ZX_FC_CODES_DENORM_B codes
4028: where
4029: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4030: and codes.classification_code = lv.lookup_code
4031: and codes.ancestor_id = nvl(l_fc_id,codes.ancestor_id)
4217: fnd_global.conc_login_id,
4218: LANGUAGE,
4219: SOURCE_LANGUAGE)
4220:
4221: INTO ZX_FC_CODES_DENORM_B(
4222: CLASSIFICATION_TYPE_ID,
4223: CLASSIFICATION_TYPE_CODE,
4224: CLASSIFICATION_TYPE_NAME,
4225: CLASSIFICATION_TYPE_CATEG_CODE,
4367: and fc.classification_id = codes.parent_classification_id
4368: and event.tax_event_class_code = 'SALES_TRANSACTION'
4369:
4370: AND NOT EXISTS -- this condition makes sure we dont duplicate data
4371: (select NULL from ZX_FC_CODES_DENORM_B denorm
4372: where
4373: denorm.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4374: and denorm.classification_code = codes.fc_code
4375: and denorm.ancestor_id = fc.classification_id
4855: SYSDATE,
4856: FND_GLOBAL.CONC_LOGIN_ID,
4857: language,
4858: source_lang)
4859: INTO ZX_FC_CODES_DENORM_B(
4860: CLASSIFICATION_TYPE_ID,
4861: CLASSIFICATION_TYPE_CODE,
4862: CLASSIFICATION_TYPE_NAME,
4863: CLASSIFICATION_TYPE_CATEG_CODE,
4977: AND LV.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
4978: AND LV.language=L.language_code(+)
4979: AND L.INSTALLED_FLAG in ('I', 'B')
4980: AND NOT EXISTS -- this condition makes sure we dont duplicate data
4981: (select NULL from ZX_FC_CODES_DENORM_B codes where
4982: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4983: and codes.classification_code = lv.lookup_code
4984: and codes.ancestor_id is null
4985: and codes.language = l.language_code);