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: );
14:
820: and codes.classification_code = lookups.lookup_code )
821: );
822:
823:
824: INSERT ALL INTO ZX_FC_CODES_TL
825: (CLASSIFICATION_ID,
826: CLASSIFICATION_NAME,
827: CREATED_BY,
828: CREATION_DATE,
1077: p_flexfield FND_FLEX_KEY_API.FLEXFIELD_TYPE;
1078: p_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1079: v_structure_id FND_FLEX_KEY_API.STRUCTURE_TYPE;
1080: v_classification_code zx_fc_codes_b.classification_code%type;
1081: v_classification_name zx_fc_codes_tl.classification_name%type;
1082: v_effective_from date;
1083: v_effective_to date;
1084: v_language zx_fc_codes_tl.language%type;
1085: v_RECORD_TYPE zx_Fc_codes_b.RECORD_TYPE_CODE%type;
1080: v_classification_code zx_fc_codes_b.classification_code%type;
1081: v_classification_name zx_fc_codes_tl.classification_name%type;
1082: v_effective_from date;
1083: v_effective_to date;
1084: v_language zx_fc_codes_tl.language%type;
1085: v_RECORD_TYPE zx_Fc_codes_b.RECORD_TYPE_CODE%type;
1086:
1087: BEGIN
1088:
1149: );
1150:
1151:
1152: INSERT ALL
1153: INTO ZX_FC_CODES_TL
1154: (CLASSIFICATION_ID,
1155: CLASSIFICATION_NAME,
1156: CREATED_BY,
1157: CREATION_DATE,
1365: nvl(fc.classification_id,codes.parent_classification_id)
1366: and codes.classification_code = ap_op.cfo_code );
1367:
1368: INSERT ALL
1369: INTO ZX_FC_CODES_TL
1370: (CLASSIFICATION_ID,
1371: CLASSIFICATION_NAME,
1372: CREATED_BY,
1373: CREATION_DATE,
1608: and codes.classification_code = lookups.lookup_code
1609: );
1610:
1611: INSERT ALL INTO
1612: ZX_FC_CODES_TL(
1613: CLASSIFICATION_ID,
1614: CLASSIFICATION_NAME,
1615: CREATED_BY,
1616: CREATION_DATE,
2047:
2048: PROCEDURE FIRST_LEVEL_FC_CODE_INSERT(
2049: p_classification_type_code IN ZX_FC_CODES_B.CLASSIFICATION_TYPE_CODE%TYPE,
2050: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2051: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2052: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2053: x_fc_id OUT NOCOPY ZX_FC_CODES_B.CLASSIFICATION_ID%TYPE
2054: )
2055: IS
2112: and codes.classification_code = p_classification_code
2113: );
2114:
2115: INSERT ALL
2116: INTO ZX_FC_CODES_TL(
2117: CLASSIFICATION_ID,
2118: CLASSIFICATION_NAME,
2119: CREATED_BY,
2120: CREATION_DATE,
2344: and codes.classification_code = lookups.lookup_code
2345: );
2346:
2347: INSERT ALL INTO
2348: ZX_FC_CODES_TL
2349: (CLASSIFICATION_ID,
2350: CLASSIFICATION_NAME,
2351: CREATED_BY,
2352: CREATION_DATE,
2511: This procedure is called from zxcfctbc.ldt file also */
2512:
2513: PROCEDURE FC_CODE_GDF_INSERT(
2514: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2515: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2516: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2517: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2518: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2519: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2606: );
2607:
2608:
2609: INSERT ALL
2610: INTO ZX_FC_CODES_TL
2611: (CLASSIFICATION_ID,
2612: CLASSIFICATION_NAME,
2613: CREATED_BY,
2614: CREATION_DATE,
2778: /*THIS IS THE COMMON PROCEDURE USED TO INSERT THE GLOBAL DESCRIPTIVE FLEXI FIELD PROMPT VALUE*/
2779:
2780: PROCEDURE GDF_PROMPT_INSERT(
2781: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2782: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2783: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2784: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
2785: )
2786:
2855: and codes.classification_code = p_classification_code
2856: );
2857:
2858: INSERT ALL
2859: INTO ZX_FC_CODES_TL
2860: (CLASSIFICATION_ID,
2861: CLASSIFICATION_NAME,
2862: CREATED_BY,
2863: CREATION_DATE,
3653: and codes.classification_code = v.flex_value
3654: );
3655:
3656: INSERT ALL
3657: INTO ZX_FC_CODES_TL(
3658: CLASSIFICATION_ID,
3659: CLASSIFICATION_NAME,
3660: CREATED_BY,
3661: CREATION_DATE,
3877: and codes.classification_code = lookups.lookup_code
3878: );
3879:
3880: INSERT ALL
3881: INTO ZX_FC_CODES_TL(
3882:
3883: CLASSIFICATION_ID,
3884: CLASSIFICATION_NAME,
3885: CREATED_BY,
4192: );
4193:
4194:
4195: INSERT ALL
4196: INTO ZX_FC_CODES_TL
4197: (CLASSIFICATION_ID,
4198: CLASSIFICATION_NAME,
4199: CREATED_BY,
4200: CREATION_DATE,
4832: and codes.classification_code = lookups.lookup_code)
4833: );
4834:
4835: INSERT ALL
4836: INTO ZX_FC_CODES_TL
4837: (CLASSIFICATION_ID,
4838: CLASSIFICATION_NAME,
4839: CREATED_BY,
4840: CREATION_DATE,