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 8773: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2

8769: PROCEDURE migrate_profile AS
8770: cursor allow_tax_line_cur is
8771: select DISTINCT
8772: fpov2.profile_option_value
8773: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8774: where fpov1.profile_option_id = (select fpo.profile_option_id
8775: from fnd_profile_options fpo
8776: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8777: and fpov1.level_id = 10003

Line 8775: from fnd_profile_options fpo

8771: select DISTINCT
8772: fpov2.profile_option_value
8773: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8774: where fpov1.profile_option_id = (select fpo.profile_option_id
8775: from fnd_profile_options fpo
8776: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8777: and fpov1.level_id = 10003
8778: and fpov1.application_id = 235
8779: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8780: from fnd_profile_options fpo

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

Line 8790: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2

8786: AND fpov1.profile_option_value = 'N'
8787: MINUS
8788: select DISTINCT
8789: fpov2.profile_option_value
8790: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8791: where fpov1.profile_option_id = (select fpo.profile_option_id
8792: from fnd_profile_options fpo
8793: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8794: and fpov1.level_id = 10003

Line 8792: from fnd_profile_options fpo

8788: select DISTINCT
8789: fpov2.profile_option_value
8790: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8791: where fpov1.profile_option_id = (select fpo.profile_option_id
8792: from fnd_profile_options fpo
8793: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8794: and fpov1.level_id = 10003
8795: and fpov1.application_id = 235
8796: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8797: from fnd_profile_options fpo

8793: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8794: and fpov1.level_id = 10003
8795: and fpov1.application_id = 235
8796: AND fpov2.profile_option_id = (select fpo.profile_option_id
8797: from fnd_profile_options fpo
8798: where fpo.profile_option_name = 'ORG_ID')
8799: and fpov2.level_id = 10003
8800: and fpov2.application_id = 0
8801: AND fpov2.level_value=fpov1.level_value

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

10407: FND_PRODUCT_GROUPS;
10408:
10409: IF L_MULTI_ORG_FLAG = 'N' THEN
10410:
10411: FND_PROFILE.GET('ORG_ID',L_ORG_ID);
10412:
10413: IF L_ORG_ID IS NULL THEN
10414: arp_util_tax.debug('MO: Operating Units site level profile option value not set , resulted in Null Org Id');
10415: END IF;