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 8214: | Lookup type = FND_LOOKUPS : JLZZ_AR_TX_RULE_SET.

8210: |
8211: | NOTES
8212: | 09/01/2004: Can be merged with P2P.
8213: | 09/24/2004: May need to implement unused lookup codes for LTE.
8214: | Lookup type = FND_LOOKUPS : JLZZ_AR_TX_RULE_SET.
8215: | Need to implement product checks.
8216: |
8217: | MODIFICATION HISTORY
8218: | 08/31/2004 Yoshimichi Konishi Created.

Line 8441: fnd_lookups lkups

8437: codes.global_attribute_category global_attribute_category
8438: from zx_rates_b rates,
8439: ar_vat_tax_all_b codes,
8440: ar_system_parameters_all params,
8441: fnd_lookups lkups
8442: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8443: 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)
8444: and params.global_attribute13 = lkups.lookup_code
8445: and params.global_attribute_category in ('JL.AR.ARXSYSPA.SYS_PARAMETERS',

Line 8472: | migrate_fnd_lookups

8468: END;
8469:
8470: /*===========================================================================+
8471: | PROCEDURE
8472: | migrate_fnd_lookups
8473: |
8474: | IN
8475: |
8476: | OUT

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

8475: |
8476: | OUT
8477: |
8478: | DESCRIPTION
8479: | This routine processes AR Tax_setup related fnd_lookups and creates
8480: | appropriate ZX lookups in FND_LOOKUPS.
8481: | AR_VAT_TAX_ALL_B.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE
8482: | AR_VAT_TAX_ALL_B.TAX_TYPE --> ZX_TAXES_B.TAX_TYPE_CODE
8483: |

Line 8480: | appropriate ZX lookups in FND_LOOKUPS.

8476: | OUT
8477: |
8478: | DESCRIPTION
8479: | This routine processes AR Tax_setup related fnd_lookups and creates
8480: | appropriate ZX lookups in FND_LOOKUPS.
8481: | AR_VAT_TAX_ALL_B.VAT_TRANSACTION_TYPE --> ZX_RATES.VAT_TRANSACTION_TYPE
8482: | AR_VAT_TAX_ALL_B.TAX_TYPE --> ZX_TAXES_B.TAX_TYPE_CODE
8483: |
8484: | SCOPE - PRIVATE

Line 8498: PROCEDURE migrate_fnd_lookups AS

8494: | MODIFICATION HISTORY
8495: | 09/16/2004 Yoshimichi Konishi Created.
8496: |
8497: +==========================================================================*/
8498: PROCEDURE migrate_fnd_lookups AS
8499: BEGIN
8500: INSERT INTO FND_LOOKUP_VALUES
8501: (
8502: LOOKUP_TYPE ,

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

9757:
9758:
9759: -- ****** STATUS ******
9760:
9761: -- Bug 4936196 : Inserting fnd_lookups.meaning for Taiwanese localization
9762: INSERT INTO ZX_STATUS_TL
9763: (
9764: TAX_STATUS_ID,
9765: TAX_STATUS_NAME,