APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on FND_PROFILE

Line 17: NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

13:
14:
15:
16: PG_DEBUG CONSTANT VARCHAR(1) DEFAULT
17: NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
18:
19: -- ****** FORWARD DECLARATIONS ******
20: PROCEDURE migrate_ar_vat_tax (p_tax_id NUMBER);
21: PROCEDURE create_zx_status (p_tax_id NUMBER);

Line 8761: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2

8757: PROCEDURE migrate_profile AS
8758: cursor allow_tax_line_cur is
8759: select DISTINCT
8760: fpov2.profile_option_value
8761: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8762: where fpov1.profile_option_id = (select fpo.profile_option_id
8763: from fnd_profile_options fpo
8764: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8765: and fpov1.level_id = 10003

Line 8763: from fnd_profile_options fpo

8759: select DISTINCT
8760: fpov2.profile_option_value
8761: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8762: where fpov1.profile_option_id = (select fpo.profile_option_id
8763: from fnd_profile_options fpo
8764: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8765: and fpov1.level_id = 10003
8766: and fpov1.application_id = 235
8767: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8768: from fnd_profile_options fpo

8764: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8765: and fpov1.level_id = 10003
8766: and fpov1.application_id = 235
8767: AND fpov2.profile_option_id = (select fpo.profile_option_id
8768: from fnd_profile_options fpo
8769: where fpo.profile_option_name = 'ORG_ID')
8770: and fpov2.level_id = 10003
8771: and fpov2.application_id = 0
8772: AND fpov2.level_value=fpov1.level_value

Line 8778: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2

8774: AND fpov1.profile_option_value = 'N'
8775: MINUS
8776: select DISTINCT
8777: fpov2.profile_option_value
8778: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8779: where fpov1.profile_option_id = (select fpo.profile_option_id
8780: from fnd_profile_options fpo
8781: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8782: and fpov1.level_id = 10003

Line 8780: from fnd_profile_options fpo

8776: select DISTINCT
8777: fpov2.profile_option_value
8778: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8779: where fpov1.profile_option_id = (select fpo.profile_option_id
8780: from fnd_profile_options fpo
8781: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8782: and fpov1.level_id = 10003
8783: and fpov1.application_id = 235
8784: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8785: from fnd_profile_options fpo

8781: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8782: and fpov1.level_id = 10003
8783: and fpov1.application_id = 235
8784: AND fpov2.profile_option_id = (select fpo.profile_option_id
8785: from fnd_profile_options fpo
8786: where fpo.profile_option_name = 'ORG_ID')
8787: and fpov2.level_id = 10003
8788: and fpov2.application_id = 0
8789: AND fpov2.level_value=fpov1.level_value

Line 10402: FND_PROFILE.GET('ORG_ID',L_ORG_ID);

10398: FND_PRODUCT_GROUPS;
10399:
10400: IF L_MULTI_ORG_FLAG = 'N' THEN
10401:
10402: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
10403:
10404: IF L_ORG_ID IS NULL THEN
10405: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
10406: END IF;