eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 837: INSERT ALL INTO ZX_FC_CODES_TL

833: )
834: );
835:
836:
837: INSERT ALL INTO ZX_FC_CODES_TL
838: (CLASSIFICATION_ID,
839: CLASSIFICATION_NAME,
840: CREATED_BY,
841: CREATION_DATE,

Line 1086: v_classification_name zx_fc_codes_tl.classification_name%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;
1090: v_RECORD_TYPE zx_Fc_codes_b.RECORD_TYPE_CODE%type;

Line 1089: v_language zx_fc_codes_tl.language%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;
1090: v_RECORD_TYPE zx_Fc_codes_b.RECORD_TYPE_CODE%type;
1091:
1092: BEGIN
1093:

Line 1158: INTO ZX_FC_CODES_TL

1154: );
1155:
1156:
1157: INSERT ALL
1158: INTO ZX_FC_CODES_TL
1159: (CLASSIFICATION_ID,
1160: CLASSIFICATION_NAME,
1161: CREATED_BY,
1162: CREATION_DATE,

Line 1373: INTO ZX_FC_CODES_TL

1369: and codes.classification_code = ap_op.cfo_code );
1370:
1371:
1372: INSERT ALL
1373: INTO ZX_FC_CODES_TL
1374: (CLASSIFICATION_ID,
1375: CLASSIFICATION_NAME,
1376: CREATED_BY,
1377: CREATION_DATE,

Line 1613: ZX_FC_CODES_TL(

1609: );
1610:
1611:
1612: INSERT ALL INTO
1613: ZX_FC_CODES_TL(
1614: CLASSIFICATION_ID,
1615: CLASSIFICATION_NAME,
1616: CREATED_BY,
1617: CREATION_DATE,

Line 2044: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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: )
2048: IS

Line 2110: INTO ZX_FC_CODES_TL(

2106: );
2107:
2108:
2109: INSERT ALL
2110: INTO ZX_FC_CODES_TL(
2111: CLASSIFICATION_ID,
2112: CLASSIFICATION_NAME,
2113: CREATED_BY,
2114: CREATION_DATE,

Line 2342: ZX_FC_CODES_TL

2338: );
2339:
2340:
2341: INSERT ALL INTO
2342: ZX_FC_CODES_TL
2343: (CLASSIFICATION_ID,
2344: CLASSIFICATION_NAME,
2345: CREATED_BY,
2346: CREATION_DATE,

Line 2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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,
2512: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE

Line 2604: INSERT INTO ZX_FC_CODES_TL

2600: );
2601:
2602:
2603:
2604: INSERT INTO ZX_FC_CODES_TL
2605: (CLASSIFICATION_ID,
2606: CLASSIFICATION_NAME,
2607: CREATED_BY,
2608: CREATION_DATE,

Line 2651: from ZX_FC_CODES_TL Codes

2647: and L.INSTALLED_FLAG in ('I', 'B')
2648: and event.tax_event_class_code = p_tax_event_class_code
2649: and NOT EXISTS -- this condition makes sure we dont duplicate data
2650: (select 1
2651: from ZX_FC_CODES_TL Codes
2652: where classification_id = inserted_fc.classification_id
2653: and language = l.language_code
2654: );
2655:

Line 2802: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,

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: )
2806:

Line 2879: INSERT INTO ZX_FC_CODES_TL

2875: and codes.classification_code = p_classification_code
2876: );
2877:
2878:
2879: INSERT INTO ZX_FC_CODES_TL
2880: (CLASSIFICATION_ID,
2881: CLASSIFICATION_NAME,
2882: CREATED_BY,
2883: CREATION_DATE,

Line 2917: (select 1 from ZX_FC_CODES_TL Codes where

2913: and fc.classification_code = fcparent.classification_code
2914: and fc.RECORD_TYPE_CODE = 'SEEDED'
2915: and event.tax_event_class_code = p_tax_event_class_code
2916: and not exists -- this condition makes sure we dont duplicate data
2917: (select 1 from ZX_FC_CODES_TL Codes where
2918: classification_id = fc.classification_id
2919: and language = l.language_code
2920: );
2921:

Line 3857: INTO ZX_FC_CODES_TL(

3853: );
3854:
3855:
3856: INSERT ALL
3857: INTO ZX_FC_CODES_TL(
3858: CLASSIFICATION_ID,
3859: CLASSIFICATION_NAME,
3860: CREATED_BY,
3861: CREATION_DATE,

Line 4082: INTO ZX_FC_CODES_TL(

4078: );
4079:
4080:
4081: INSERT ALL
4082: INTO ZX_FC_CODES_TL(
4083:
4084: CLASSIFICATION_ID,
4085: CLASSIFICATION_NAME,
4086: CREATED_BY,

Line 4408: INTO ZX_FC_CODES_TL

4404:
4405:
4406:
4407: INSERT ALL
4408: INTO ZX_FC_CODES_TL
4409: (CLASSIFICATION_ID,
4410: CLASSIFICATION_NAME,
4411: CREATED_BY,
4412: CREATION_DATE,

Line 4590: AND NOT EXISTS (select NULL from ZX_FC_CODES_TL fctl

4586: denorm.classification_type_code = G_CLASSIFICATION_TYPE_CODE
4587: and denorm.classification_code = codes.fc_code
4588: and denorm.ancestor_id = fc.classification_id
4589: and denorm.language = codes.language)
4590: AND NOT EXISTS (select NULL from ZX_FC_CODES_TL fctl
4591: where fctl.classification_id = fc.classification_id
4592: and fctl.language = codes.language);
4593:
4594:

Line 5061: INTO ZX_FC_CODES_TL

5057: );
5058:
5059:
5060: INSERT ALL
5061: INTO ZX_FC_CODES_TL
5062: (CLASSIFICATION_ID,
5063: CLASSIFICATION_NAME,
5064: CREATED_BY,
5065: CREATION_DATE,