DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_FC_CODES_TL

Line 10: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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:

Line 824: INSERT ALL INTO ZX_FC_CODES_TL

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,

Line 1081: v_classification_name zx_fc_codes_tl.classification_name%type;

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;

Line 1084: v_language zx_fc_codes_tl.language%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:

Line 1153: INTO ZX_FC_CODES_TL

1149: );
1150:
1151:
1152: INSERT ALL
1153: INTO ZX_FC_CODES_TL
1154: (CLASSIFICATION_ID,
1155: CLASSIFICATION_NAME,
1156: CREATED_BY,
1157: CREATION_DATE,

Line 1369: INTO ZX_FC_CODES_TL

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,

Line 1612: ZX_FC_CODES_TL(

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,

Line 2051: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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

Line 2116: INTO ZX_FC_CODES_TL(

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,

Line 2348: ZX_FC_CODES_TL

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,

Line 2515: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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

Line 2610: INTO ZX_FC_CODES_TL

2606: );
2607:
2608:
2609: INSERT ALL
2610: INTO ZX_FC_CODES_TL
2611: (CLASSIFICATION_ID,
2612: CLASSIFICATION_NAME,
2613: CREATED_BY,
2614: CREATION_DATE,

Line 2782: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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:

Line 2859: INTO ZX_FC_CODES_TL

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,

Line 3657: INTO ZX_FC_CODES_TL(

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,

Line 3881: INTO ZX_FC_CODES_TL(

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,

Line 4196: INTO ZX_FC_CODES_TL

4192: );
4193:
4194:
4195: INSERT ALL
4196: INTO ZX_FC_CODES_TL
4197: (CLASSIFICATION_ID,
4198: CLASSIFICATION_NAME,
4199: CREATED_BY,
4200: CREATION_DATE,

Line 4836: INTO ZX_FC_CODES_TL

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,