APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on FND_LOOKUPS

Line 24: PROCEDURE migrate_fnd_lookups;

20: PROCEDURE migrate_ar_vat_tax (p_tax_id NUMBER);
21: PROCEDURE create_zx_status (p_tax_id NUMBER);
22: PROCEDURE create_zx_taxes (p_tax_id NUMBER);
23: PROCEDURE create_zx_regimes (p_tax_id NUMBER);
24: PROCEDURE migrate_fnd_lookups;
25: PROCEDURE create_tax_classifications (p_tax_id NUMBER);
26: PROCEDURE migrate_profile;
27: PROCEDURE backward_updation; --bug4216592: activating it
28: PROCEDURE insert_tax_for_loc (p_min_start_date DATE,

Line 159: arp_util_tax.debug('b: migrate_fnd_lookups');

155: arp_util_tax.debug('b: create_zx_regimes');
156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');

Line 160: migrate_fnd_lookups;

156: --create_zx_regimes (p_tax_id);
157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');
164: migrate_profile;

Line 161: arp_util_tax.debug('a: migrate_fnd_lookups');

157: arp_util_tax.debug('a: create_zx_regimes');
158:
159: arp_util_tax.debug('b: migrate_fnd_lookups');
160: migrate_fnd_lookups;
161: arp_util_tax.debug('a: migrate_fnd_lookups');
162:
163: arp_util_tax.debug('b: migrate_profile');
164: migrate_profile;
165: arp_util_tax.debug('a: migrate_profile');

Line 8202: | Lookup type = FND_LOOKUPS : JLZZ_AR_TX_RULE_SET.

8198: |
8199: | NOTES
8200: | 09/01/2004: Can be merged with P2P.
8201: | 09/24/2004: May need to implement unused lookup codes for LTE.
8202: | Lookup type = FND_LOOKUPS : JLZZ_AR_TX_RULE_SET.
8203: | Need to implement product checks.
8204: |
8205: | MODIFICATION HISTORY
8206: | 08/31/2004 Yoshimichi Konishi Created.

Line 8429: fnd_lookups lkups

8425: codes.global_attribute_category global_attribute_category
8426: from zx_rates_b rates,
8427: ar_vat_tax_all_b codes,
8428: ar_system_parameters_all params,
8429: fnd_lookups lkups
8430: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8431: AND decode(l_multi_org_flag,'N',l_org_id,codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,params.org_id)
8432: and params.global_attribute13 = lkups.lookup_code
8433: and params.global_attribute_category in ('JL.AR.ARXSYSPA.SYS_PARAMETERS',

Line 8460: | migrate_fnd_lookups

8456: END;
8457:
8458: /*===========================================================================+
8459: | PROCEDURE
8460: | migrate_fnd_lookups
8461: |
8462: | IN
8463: |
8464: | OUT

Line 8467: | This routine processes AR Tax_setup related fnd_lookups and creates

8463: |
8464: | OUT
8465: |
8466: | DESCRIPTION
8467: | This routine processes AR Tax_setup related fnd_lookups and creates
8468: | appropriate ZX lookups in FND_LOOKUPS.
8469: | AR_VAT_TAX_ALL_B.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE
8470: | AR_VAT_TAX_ALL_B.TAX_TYPE --> ZX_TAXES_B.TAX_TYPE_CODE
8471: |

Line 8468: | appropriate ZX lookups in FND_LOOKUPS.

8464: | OUT
8465: |
8466: | DESCRIPTION
8467: | This routine processes AR Tax_setup related fnd_lookups and creates
8468: | appropriate ZX lookups in FND_LOOKUPS.
8469: | AR_VAT_TAX_ALL_B.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE
8470: | AR_VAT_TAX_ALL_B.TAX_TYPE --> ZX_TAXES_B.TAX_TYPE_CODE
8471: |
8472: | SCOPE - PRIVATE

Line 8486: PROCEDURE migrate_fnd_lookups AS

8482: | MODIFICATION HISTORY
8483: | 09/16/2004 Yoshimichi Konishi Created.
8484: |
8485: +==========================================================================*/
8486: PROCEDURE migrate_fnd_lookups AS
8487: BEGIN
8488: INSERT INTO FND_LOOKUP_VALUES
8489: (
8490: LOOKUP_TYPE ,

Line 9749: -- Bug 4936196 : Inserting fnd_lookups.meaning for Taiwanese localization

9745:
9746:
9747: -- ****** STATUS ******
9748:
9749: -- Bug 4936196 : Inserting fnd_lookups.meaning for Taiwanese localization
9750: INSERT INTO ZX_STATUS_TL
9751: (
9752: TAX_STATUS_ID,
9753: TAX_STATUS_NAME,