[Home] [Help]
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 */
16: PROCEDURE ASSOCIATE_ITEMS(
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'
1357: and fc.ancestor_code = event.tax_event_class_code
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
1507: WHERE
1508: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1509: and fc.classification_code='OPERATION FISCAL CODE'
1510: and fc.language = userenv('LANG')
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
2520: )
2521:
2522: IS
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'
2592: and fc.classification_code=p_classification_code
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
2752: WHERE fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2753: and fc.classification_code=p_classification_code
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:
2787: IS
2788:
4167:
4168: FROM
4169:
4170: ZX_FC_CODES_B fc,
4171: ZX_EVENT_CLASSES_VL event,
4172: (SELECT
4173: lookups.LOOKUP_CODE fc_code,
4174: nvl(START_DATE_ACTIVE,to_date('01/01/1951','DD/MM/YYYY')) effective_from,
4175: END_DATE_ACTIVE effective_to
4331: codes.enabled_flag
4332: FROM
4333:
4334: ZX_FC_CODES_B fc,
4335: ZX_EVENT_CLASSES_VL event,
4336:
4337: (SELECT
4338: FL.LOOKUP_CODE fc_code,
4339: FL.MEANING fc_name,