[Home] [Help]
5: l_org_id NUMBER(15);
6:
7: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE GLOBAL DESCRIPTIVE FLEXI FIELD PROMPT VALUE*/
8: PROCEDURE GDF_PROMPT_INSERT(
9: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
10: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
11: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
12: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
13: );
7: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE GLOBAL DESCRIPTIVE FLEXI FIELD PROMPT VALUE*/
8: PROCEDURE GDF_PROMPT_INSERT(
9: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
10: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
11: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
12: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
13: );
14:
15: /* COMMON PROCEDURE USED TO ASSOCIATE THE ITEMS */
668: l_start_date_active fnd_lookup_values.start_date_active%type;
669: l_end_date_active fnd_lookup_values.end_date_active%type;
670: l_source_lang fnd_lookup_values.source_lang%type;
671: i integer := 0;
672: l_fc_id zx_fc_codes_b.classification_id%type;
673: l_return_status varchar2(200);
674: l_errorcode number;
675: l_msg_count number;
676: l_MSG_DATA varchar2(200);
756:
757: /* Create Codes under Product Category Statistical Code */
758: arp_util_tax.debug( 'Creating the Statistical Code.. ');
759:
760: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;
761:
762: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','STATISTICAL_CODE','Statistical Code',NULL,l_fc_id);
763:
764: FC_CODE_FROM_FND_LOOKUP('PRODUCT_CATEGORY','JGZZ_STATISTICAL_CODE',NULL,l_fc_id,'STATISTICAL_CODE','Statistical Code',2);
789:
790: CLOSE G_C_GET_TYPES_INFO;
791: /* Removed the reference to obsolete object JL_BR_PO_FISC_CLASSIF_ALL. Bug # 5150296 */
792: INSERT
793: INTO ZX_FC_CODES_B
794: (classification_type_code,
795: classification_id,
796: classification_code,
797: effective_from,
807: last_update_login,
808: object_version_number)
809: (SELECT
810: 'PRODUCT_CATEGORY',
811: zx_fc_codes_b_s.nextval,
812: lookups.LOOKUP_CODE fc_code,
813: nvl(START_DATE_ACTIVE, to_date('01/01/1951','DD/MM/YYYY')) effective_from,
814: END_DATE_ACTIVE effective_to,
815: 'FISCAL CLASSIFICATION CODE',--parent_classification_code
825: FROM FND_LOOKUPS lookups
826: WHERE lookups.LOOKUP_TYPE = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
827: AND NOT EXISTS -- this condition makes sure we dont duplicate data
828: (select NULL
829: from ZX_FC_CODES_B Codes
830: where codes.classification_type_code = 'PRODUCT_CATEGORY'
831: and codes.parent_classification_id = nvl(l_fc_id,codes.parent_classification_id)
832: and codes.classification_code = lookups.lookup_code
833: )
963: FL.LANGUAGE LANGUAGE,
964: FL.SOURCE_LANG SOURCE_LANGUAGE,
965: codes.classification_id
966: FROM
967: ZX_FC_CODES_b Codes,
968: FND_LOOKUP_VALUES FL,
969: FND_LANGUAGES L
970: WHERE Codes.classification_type_code = 'PRODUCT_CATEGORY'
971: AND Codes.parent_classification_id=l_fc_id
1076: FROM mtl_category_sets
1077: WHERE Category_Set_Name ='WINE_CIGARRETE_CATEGORY';
1078:
1079: l_LANGUAGE zx_fc_types_tl.language%type;
1080: l_fc_id zx_fc_codes_b.classification_id%type;
1081: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1082: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1083: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1084: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1081: p_category_set mtl_category_sets_vl.Category_set_ID%TYPE;
1082: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1083: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1084: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1085: v_classification_code zx_fc_codes_b.classification_code%type;
1086: v_classification_name zx_fc_codes_tl.classification_name%type;
1087: v_effective_from date;
1088: v_effective_to date;
1089: v_language zx_fc_codes_tl.language%type;
1086: v_classification_name zx_fc_codes_tl.classification_name%type;
1087: v_effective_from date;
1088: v_effective_to date;
1089: v_language zx_fc_codes_tl.language%type;
1090: v_RECORD_TYPE zx_Fc_codes_b.RECORD_TYPE_CODE%type;
1091:
1092: BEGIN
1093:
1094: arp_util_tax.debug( ' FC_ENTITIES .. (+) ' );
1112:
1113: CLOSE G_C_GET_TYPES_INFO;
1114:
1115: INSERT
1116: INTO ZX_FC_CODES_B
1117: (classification_type_code,
1118: classification_id,
1119: classification_code,
1120: effective_from,
1129: last_update_date,
1130: last_update_login,
1131: object_version_number)
1132: (SELECT 'USER_DEFINED',
1133: zx_fc_codes_b_s.nextval,
1134: cfo_code,
1135: creation_date,
1136: null,
1137: null,----parent_classification_code
1146: 1
1147: FROM JL_BR_AP_OPERATIONS JLBR
1148: WHERE NOT EXISTS
1149: -- this condition makes sure we dont duplicate data
1150: (select NULL from ZX_FC_CODES_B Codes where
1151: codes.classification_type_code = 'USER_DEFINED'
1152: and codes.parent_classification_id is null
1153: and codes.classification_code = jlbr.cfo_code)
1154: );
1279: NVL(cfo_description,cfo_code) Meaning,
1280: JLBR.creation_date ,
1281: l.language_code lang_code,
1282: codes.classification_id
1283: FROM ZX_FC_CODES_B Codes,
1284: JL_BR_AP_OPERATIONS JLBR,
1285: FND_LANGUAGES L
1286: WHERE Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1287: and Codes.parent_classification_id is null
1316:
1317: arp_util_tax.debug( 'Create Code under the Transaction Business Category Type-Level 3: BR');
1318:
1319: INSERT
1320: INTO ZX_FC_CODES_B (
1321: classification_type_code,
1322: classification_id,
1323: classification_code,
1324: effective_from,
1335: object_version_number
1336: )
1337: SELECT
1338: 'TRX_BUSINESS_CATEGORY',
1339: zx_fc_codes_b_s.nextval,
1340: cfo_code ,
1341: ap_op.creation_date,
1342: null,
1343: fc.classification_code,--parent_classification_code
1361: and fc.language = userenv('LANG')
1362: and fc.classification_code_level = 2
1363: and event.tax_event_class_code = 'PURCHASE_TRANSACTION'
1364: and NOT EXISTS -- this condition makes sure we dont duplicate data
1365: ( select NULL from ZX_FC_CODES_B Codes where
1366: codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1367: and codes.parent_classification_id =
1368: nvl(fc.classification_id,codes.parent_classification_id)
1369: and codes.classification_code = ap_op.cfo_code );
1502: codes.classification_id,
1503: l.language_code lang_code
1504: FROM
1505: ZX_FC_CODES_DENORM_B fc,
1506: ZX_FC_CODES_B Codes,
1507: JL_BR_AP_OPERATIONS ap_op,
1508: FND_LANGUAGES L,
1509: ZX_EVENT_CLASSES_VL event
1510: WHERE
1563:
1564: arp_util_tax.debug( 'Create Codes on level 2 for country : TAIWAN ');
1565:
1566: INSERT
1567: INTO ZX_FC_CODES_B (
1568: classification_type_code,
1569: classification_id,
1570: classification_code,
1571: effective_from,
1581: last_update_login,
1582: object_version_number)
1583: SELECT
1584: 'DOCUMENT_SUBTYPE',
1585: zx_fc_codes_b_s.nextval,
1586: lookup_code, --classification_code
1587: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')), --effective_from
1588: end_date_active, --effective_to
1589: 'GUI TYPE', --parent_classification_code
1600: FROM FND_LOOKUP_VALUES lookups
1601: WHERE lookups.lookup_type='JATW_GUI_TYPE'
1602: AND LANGUAGE = userenv('LANG')
1603: AND NOT EXISTS -- this condition makes sure we dont duplicate data
1604: (select NULL from ZX_FC_CODES_B Codes where
1605: codes.classification_type_code = 'DOCUMENT_SUBTYPE'
1606: and codes.parent_classification_id =
1607: nvl(l_fc_id,codes.parent_classification_id)
1608: and codes.classification_code = lookups.lookup_code
1741: language,
1742: lv.enabled_flag,
1743: classification_id
1744: FROM
1745: ZX_FC_CODES_B Codes,
1746: FND_LOOKUP_VALUES LV,
1747: FND_LANGUAGES L
1748: WHERE Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
1749: AND Codes.parent_classification_id = l_fc_id
2038:
2039: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE FIRST LEVEL FC CODES*/
2040:
2041: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
2042: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2043: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2044: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2045: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2046: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE
2039: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE FIRST LEVEL FC CODES*/
2040:
2041: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
2042: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2043: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2044: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2045: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2046: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE
2047: )
2041: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
2042: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2043: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2044: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2045: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2046: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE
2047: )
2048: IS
2049:
2042: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2043: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2044: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2045: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2046: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE
2047: )
2048: IS
2049:
2050: BEGIN
2063: G_DELIMITER;
2064:
2065: CLOSE G_C_GET_TYPES_INFO;
2066:
2067: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2068:
2069: INSERT
2070: INTO ZX_FC_CODES_B (
2071: classification_type_code,
2066:
2067: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2068:
2069: INSERT
2070: INTO ZX_FC_CODES_B (
2071: classification_type_code,
2072: classification_id,
2073: classification_code,
2074: effective_from,
2083: last_update_login,
2084: object_version_number)
2085: SELECT
2086: p_classification_type_code,
2087: zx_fc_codes_b_s.nextval,
2088: p_classification_code,
2089: Sysdate,
2090: Null,
2091: Null, ---parent_classification_code
2098: FND_GLOBAL.CONC_LOGIN_ID,
2099: 1
2100: FROM DUAL
2101: WHERE NOT EXISTS
2102: (select NULL from ZX_FC_CODES_B Codes where
2103: codes.classification_type_code = p_classification_type_code
2104: and codes.parent_classification_id is null
2105: and codes.classification_code = p_classification_code
2106: );
2231: select
2232: language_code lang_code, fc_codes.classification_id
2233: from
2234: fnd_languages l,
2235: zx_fc_codes_b fc_codes
2236: where
2237: l.installed_flag in ('I', 'B')
2238: and fc_codes.classification_type_code = p_classification_type_code
2239: and fc_codes.parent_classification_id is null
2249: -- Find and return the classification id
2250: SELECT
2251: classification_id into x_fc_id
2252: from
2253: ZX_FC_CODES_B Codes
2254: where
2255: codes.classification_type_code = p_classification_type_code
2256: and codes.parent_classification_id is null
2257: and codes.classification_code = p_classification_code;
2264:
2265: /*THIS IS THE COMMON PROCEDURE USED TO INSERT VALUES BASED UPON THE LOOKUP TYPE */
2266:
2267: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
2268: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2269: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2270: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2271: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2272: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2266:
2267: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
2268: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2269: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2270: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2271: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2272: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2273: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
2274: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE)
2267: PROCEDURE FC_CODE_FROM_FND_LOOKUP(
2268: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2269: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2270: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2271: p_parent_fc_id IN ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE,
2272: p_ancestor_code IN ZX_FC_CODES_DENORM_B.ANCESTOR_CODE%TYPE,
2273: p_ancestor_name IN ZX_FC_CODES_DENORM_B.ANCESTOR_NAME%TYPE,
2274: p_classification_code_level IN ZX_FC_CODES_DENORM_B.CLASSIFICATION_CODE_LEVEL%TYPE)
2275: IS
2292:
2293: CLOSE G_C_GET_TYPES_INFO;
2294:
2295: INSERT
2296: INTO ZX_FC_CODES_B
2297: (classification_type_code,
2298: classification_id,
2299: classification_code,
2300: effective_from,
2309: last_update_date,
2310: last_update_login,
2311: object_version_number)
2312: SELECT p_classification_type_code,
2313: zx_fc_codes_b_s.nextval,
2314: lookup_code,
2315: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
2316: end_date_active,
2317: p_ancestor_code,----parent_classification_code
2329: lookups.lookup_type=p_lookup_type
2330: AND LANGUAGE = userenv('LANG')
2331: AND lookups.enabled_flag = 'Y'
2332: AND NOT EXISTS -- this condition makes sure we dont duplicate data
2333: (select NULL from ZX_FC_CODES_B Codes where
2334: codes.classification_type_code = p_classification_type_code
2335: and ( codes.parent_classification_id = p_parent_fc_id or
2336: p_parent_fc_id is null )
2337: and codes.classification_code = lookups.lookup_code
2471: end_date_active,
2472: fl.enabled_flag,
2473: Codes.classification_id
2474: FROM
2475: zx_fc_codes_b Codes,
2476: fnd_lookup_values fl,
2477: fnd_languages l
2478: WHERE
2479:
2503: /*THIS IS THE COMMON PROCEDURE USED TO PERFORM INSERTS BASED ON THE GLOBAL DESCRIPTIVE FLEXI FIELDS
2504: This procedure is called from zxcfctbc.ldt file also */
2505:
2506: PROCEDURE FC_CODE_GDF_INSERT(
2507: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2509: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2505:
2506: PROCEDURE FC_CODE_GDF_INSERT(
2507: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2509: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2512: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2513: )
2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2509: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2512: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2513: )
2514:
2515: IS
2516:
2543:
2544: arp_util_tax.debug( 'Create Code under the Transaction Business Category Type-Level 3: ' || p_country_code);
2545:
2546: INSERT
2547: INTO ZX_FC_CODES_B (
2548: classification_type_code,
2549: classification_id,
2550: classification_code,
2551: effective_from,
2561: last_update_login,
2562: object_version_number)
2563: SELECT
2564: fc.classification_type_code,
2565: zx_fc_codes_b_s.nextval,
2566: lookup_code,
2567: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,
2568: end_date_active,
2569: fc.classification_code ,---parent_classification_code
2591: and fl.language = userenv('LANG')
2592: and event.tax_event_class_code = p_tax_event_class_code
2593: and NOT EXISTS -- this condition makes sure we dont duplicate data
2594: (select NULL
2595: from ZX_FC_CODES_B Codes
2596: where codes.classification_type_code = fc.classification_type_code
2597: and codes.parent_classification_id =
2598: nvl(fc.classification_id,codes.parent_classification_id)
2599: and codes.classification_code = fl.lookup_code
2626: FROM
2627: ZX_FC_CODES_DENORM_B fc,
2628: ZX_EVENT_CLASSES_VL event,
2629: FND_LOOKUP_VALUES FL,
2630: zx_fc_codes_b inserted_fc,
2631: FND_LANGUAGES L
2632: WHERE
2633: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2634: and fc.classification_code=p_classification_code
2753: FND_GLOBAL.CONC_LOGIN_ID,
2754: p_record_type_code
2755: FROM
2756: ZX_FC_CODES_DENORM_B fc,
2757: ZX_FC_CODES_b Codes,
2758: ZX_EVENT_CLASSES_VL event,
2759: FND_LOOKUP_VALUES FL,
2760: FND_LANGUAGES L
2761: WHERE fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2797:
2798: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE GLOBAL DESCRIPTIVE FLEXI FIELD PROMPT VALUE*/
2799:
2800: PROCEDURE GDF_PROMPT_INSERT(
2801: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2802: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2803: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2804: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
2805: )
2799:
2800: PROCEDURE GDF_PROMPT_INSERT(
2801: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2802: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2803: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2804: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
2805: )
2806:
2807: IS
2826:
2827: CLOSE G_C_GET_TYPES_INFO;
2828:
2829: INSERT
2830: INTO ZX_FC_CODES_B
2831: (classification_type_code,
2832: classification_id,
2833: classification_code,
2834: effective_from,
2844: last_update_login,
2845: object_version_number)
2846: SELECT
2847: 'TRX_BUSINESS_CATEGORY', --classification_type_code
2848: zx_fc_codes_b_s.nextval, --classification_id
2849: p_classification_code, --classification_code
2850: sysdate, --effective_from
2851: null, --effective_to
2852: event.tax_event_class_code, --parent_classification_code
2859: sysdate,
2860: fnd_global.conc_login_id,
2861: 1
2862: FROM
2863: ZX_FC_CODES_B fc,
2864: ZX_EVENT_CLASSES_B event
2865: WHERE
2866: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2867: and fc.parent_classification_id is null
2867: and fc.parent_classification_id is null
2868: and fc.classification_code=event.tax_event_class_code
2869: and event.tax_event_class_code = p_tax_event_class_code
2870: and not exists -- this condition makes sure we dont duplicate data
2871: (select NULL from ZX_FC_CODES_B Codes where
2872: codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2873: and codes.parent_classification_id =
2874: nvl(fc.classification_id,codes.parent_classification_id)
2875: and codes.classification_code = p_classification_code
2899: fnd_global.conc_login_id,
2900: L.language_code,
2901: userenv('LANG')
2902: FROM
2903: ZX_FC_CODES_B fcparent,
2904: ZX_FC_CODES_B fc,
2905: ZX_EVENT_CLASSES_B event,
2906: FND_LANGUAGES L
2907: WHERE
2900: L.language_code,
2901: userenv('LANG')
2902: FROM
2903: ZX_FC_CODES_B fcparent,
2904: ZX_FC_CODES_B fc,
2905: ZX_EVENT_CLASSES_B event,
2906: FND_LANGUAGES L
2907: WHERE
2908: fcparent.classification_type_code = 'TRX_BUSINESS_CATEGORY'
3018: 235,
3019: fnd_global.conc_login_id,
3020: 'SEEDED'
3021: FROM
3022: ZX_FC_CODES_B fc,
3023: ZX_FC_CODES_B zx,
3024: ZX_EVENT_CLASSES_TL event,
3025: FND_LANGUAGES L
3026: WHERE
3019: fnd_global.conc_login_id,
3020: 'SEEDED'
3021: FROM
3022: ZX_FC_CODES_B fc,
3023: ZX_FC_CODES_B zx,
3024: ZX_EVENT_CLASSES_TL event,
3025: FND_LANGUAGES L
3026: WHERE
3027: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
3488: /* PROCEDURE USED TO INSERT THE FC TYPES/CODES FOR AP ENTITIES */
3489:
3490: PROCEDURE ZX_MIGRATE_AP IS
3491:
3492: l_fc_id zx_fc_codes_b.classification_id%type;
3493:
3494: l_structure_id mtl_category_sets_b.structure_id%TYPE;
3495: l_category_status VARCHAR2(200);
3496: l_category_set mtl_category_sets_b.Category_set_ID%TYPE;
3805:
3806: arp_util_tax.debug( 'Create the Document Subtype for Fiscal Type : FRANCE ');
3807:
3808: INSERT
3809: INTO ZX_FC_CODES_B (
3810: classification_type_code,
3811: classification_id,
3812: classification_code,
3813: effective_from,
3823: last_update_login,
3824: object_version_number)
3825: SELECT
3826: 'DOCUMENT_SUBTYPE',
3827: zx_fc_codes_b_s.nextval,
3828: flex_value,
3829: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
3830: end_date_active,
3831: 'DEDUCTION TAX RULE',--parent_classification_code
3844: WHERE v.FLEX_VALUE_SET_ID = vs.FLEX_VALUE_SET_id
3845: AND vs.FLEX_VALUE_SET_NAME ='JE_FR_TAX_RULE'
3846: AND v.enabled_flag = 'Y'
3847: AND NOT EXISTS
3848: (select NULL from ZX_FC_CODES_B Codes where
3849: codes.classification_type_code = 'DOCUMENT_SUBTYPE'
3850: and codes.parent_classification_id =
3851: nvl(l_fc_id,codes.parent_classification_id)
3852: and codes.classification_code = v.flex_value
3982: Codes.classification_id,
3983: L.language_code lang_code,
3984: v.enabled_flag
3985: FROM
3986: ZX_FC_CODES_B Codes,
3987: FND_FLEX_VALUES V,
3988: fnd_flex_value_sets vs,
3989: FND_LANGUAGES L
3990:
4032:
4033: arp_util_tax.debug( 'Create a Code under the Document Subtype Fiscal Type for country : CHILE ');
4034:
4035: INSERT
4036: INTO ZX_FC_CODES_B (
4037: classification_type_code,
4038: classification_id,
4039: classification_code,
4040: effective_from,
4050: last_update_login,
4051: object_version_number)
4052: SELECT
4053: 'DOCUMENT_SUBTYPE',
4054: zx_fc_codes_b_s.nextval,
4055: lookup_code,
4056: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
4057: end_date_active,
4058: 'DOCUMENT TYPE',--parent_classification_code
4070: WHERE
4071:
4072: lookups.lookup_type='JLCL_AP_DOCUMENT_TYPE'
4073: AND NOT EXISTS -- this condition makes sure we dont duplicate data
4074: (select NULL from ZX_FC_CODES_B Codes where
4075: codes.classification_type_code = 'DOCUMENT_SUBTYPE'
4076: and codes.parent_classification_id = nvl(l_fc_id,codes.parent_classification_id)
4077: and codes.classification_code = lookups.lookup_code
4078: );
4209: language,
4210: lv.enabled_flag,
4211: classification_id
4212: FROM
4213: ZX_FC_CODES_B codes,
4214: FND_LOOKUP_VALUES LV,
4215: FND_LANGUAGES L
4216: WHERE
4217: codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4342: G_DELIMITER;
4343: CLOSE G_C_GET_TYPES_INFO;
4344:
4345: INSERT
4346: INTO ZX_FC_CODES_B
4347: (classification_type_code,
4348: classification_id,
4349: classification_code,
4350: effective_from,
4360: last_update_login,
4361: object_version_number)
4362: SELECT
4363: 'TRX_BUSINESS_CATEGORY', --classification_type_code
4364: zx_fc_codes_b_s.nextval, --classification_id
4365: lookups.fc_code, --classification_code
4366: lookups.effective_from, --effective_from
4367: lookups.effective_to, --effective_to
4368: event.tax_event_class_code, --parent_classification_code
4377: 1
4378:
4379: FROM
4380:
4381: ZX_FC_CODES_B fc,
4382: ZX_EVENT_CLASSES_VL event,
4383: (SELECT
4384: lookups.LOOKUP_CODE fc_code,
4385: nvl(START_DATE_ACTIVE,to_date('01/01/1951','DD/MM/YYYY')) effective_from,
4395: and fc.parent_classification_id is null
4396: and fc.classification_code=event.tax_event_class_code
4397: and event.tax_event_class_code = 'SALES_TRANSACTION'
4398: AND NOT EXISTS -- this condition makes sure we dont duplicate data
4399: (select NULL from ZX_FC_CODES_B Codes where
4400: codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
4401: and codes.parent_classification_id = fc.classification_id
4402: and codes.classification_code = lookups.fc_code
4403: );
4540: codes.classification_id,
4541: codes.enabled_flag
4542: FROM
4543:
4544: ZX_FC_CODES_B fc,
4545: ZX_EVENT_CLASSES_VL event,
4546:
4547: (SELECT
4548: FL.LOOKUP_CODE fc_code,
4557: ROW_NUMBER()
4558: OVER (PARTITION BY lookup_code, language
4559: ORDER BY nvl(start_date_active, to_date('01/01/1951','DD/MM/YYYY'))) AS count_num
4560: FROM
4561: ZX_FC_CODES_b Codes,
4562: FND_LOOKUP_VALUES FL,
4563: FND_LANGUAGES L
4564: WHERE
4565: Codes.classification_type_code = 'TRX_BUSINESS_CATEGORY'
4835: l_language fnd_lookup_values.language%type;
4836: l_start_date_active fnd_lookup_values.start_date_active%type;
4837: l_end_date_active fnd_lookup_values.end_date_active%type;
4838: l_source_lang fnd_lookup_values.source_lang%type;
4839: l_fc_id zx_fc_codes_b.classification_id%type;
4840: l_return_status varchar2(200);
4841: -- l_errorcode number;
4842: -- l_msg_count number;
4843: -- l_MSG_DATA varchar2(200);
5013:
5014: CLOSE G_C_GET_TYPES_INFO;
5015:
5016: INSERT
5017: INTO ZX_FC_CODES_B
5018: (classification_type_code,
5019: classification_id,
5020: classification_code,
5021: effective_from,
5030: last_update_date,
5031: last_update_login,
5032: object_version_number)
5033: (SELECT 'USER_DEFINED',
5034: zx_fc_codes_b_s.nextval,
5035: lookup_code, --classification_code
5036: nvl(start_date_active,sysdate), --effective_from
5037: end_date_active, --effective_to
5038: null,----parent_classification_code
5049: WHERE lookups.lookup_type='AR_TAX_TRX_BUSINESS_CATEGORY'
5050: AND LANGUAGE = userenv('LANG')
5051: AND NOT EXISTS
5052: -- this condition makes sure we dont duplicate data
5053: (select NULL from ZX_FC_CODES_B Codes where
5054: codes.classification_type_code = 'USER_DEFINED'
5055: and codes.parent_classification_id is null
5056: and codes.classification_code = lookups.lookup_code)
5057: );
5187: language,
5188: lv.enabled_flag,
5189: classification_id
5190: FROM
5191: ZX_FC_CODES_B Codes,
5192: FND_LOOKUP_VALUES LV,
5193: FND_LANGUAGES L
5194: WHERE
5195: Codes.classification_type_code = G_CLASSIFICATION_TYPE_CODE