APPS.FA_BALREP_PKG dependencies on FND_PROFILE

Line 20: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', p_total_requests);

16: CURSOR c_workers(request_id_in NUMBER) IS
17: SELECT ROWID FROM fa_worker_jobs WHERE request_id = request_id_in;
18:
19: BEGIN
20: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', p_total_requests);
21: fnd_profile.get('FA_BATCH_SIZE', l_batch_size);
22: l_batch_size := nvl(l_batch_size, 1000);
23: p_total_requests := nvl(p_total_requests, 1);
24:

Line 21: fnd_profile.get('FA_BATCH_SIZE', l_batch_size);

17: SELECT ROWID FROM fa_worker_jobs WHERE request_id = request_id_in;
18:
19: BEGIN
20: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', p_total_requests);
21: fnd_profile.get('FA_BATCH_SIZE', l_batch_size);
22: l_batch_size := nvl(l_batch_size, 1000);
23: p_total_requests := nvl(p_total_requests, 1);
24:
25: IF (NVL (p_total_requests, 0) > 0 and NVL (p_total_requests, 0) < 2)

Line 182: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN

178: h_reporting_flag := 'P';
179: END IF;
180:
181: -- Fix for Bug #1892406. Run only if CRL not installed.
182: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN
183:
184: IF (h_reporting_flag = 'R') THEN
185: /* Bug 7498880: Added new query for upgraded periods */
186: INSERT INTO fa_balances_reports_itf

Line 411: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

407: aj.source_type_code;
408: END IF;
409:
410: -- Fix for Bug #1892406. Run only if CRL installed.
411: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
412:
413: IF (h_reporting_flag = 'R') THEN
414: /* Bug 7498880: Added new query for upgraded periods */
415: INSERT INTO fa_balances_reports_itf

Line 820: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

816: h_reporting_flag := 'P';
817: END IF;
818:
819: -- run only if CRL installed
820: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
821:
822: IF (h_reporting_flag = 'R') THEN
823: /* Bug 7498880: Added new query for upgraded periods */
824: INSERT INTO fa_balances_reports_itf

Line 1128: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN

1124: h_reporting_flag := 'P';
1125: END IF;
1126:
1127: -- Fix for Bug #1892406. Run only if CRL not installed.
1128: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'N') THEN
1129:
1130: IF (h_reporting_flag = 'R') THEN
1131:
1132: INSERT INTO fa_balances_reports_itf

Line 1444: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

1440:
1441: END IF;
1442:
1443: -- Fix for Bug #1892406. Run only if CRL installed.
1444: ELSIF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
1445:
1446: IF (h_reporting_flag = 'R') THEN
1447: INSERT INTO fa_balances_reports_itf
1448: (asset_id,

Line 1708: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

1704: h_reporting_flag := 'P';
1705: END IF;
1706:
1707: -- run only if CRL installed
1708: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
1709:
1710: IF (report_type NOT IN ('RESERVE')) THEN
1711: IF (h_reporting_flag = 'R') THEN
1712: INSERT INTO fa_balances_reports_itf

Line 2066: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

2062: h_reporting_flag := 'P';
2063: END IF;
2064:
2065: -- run only if CRL installed
2066: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2067:
2068: IF report_type NOT IN ('RESERVE') THEN
2069: IF (h_reporting_flag = 'R') THEN
2070: INSERT INTO fa_balances_reports_itf

Line 2571: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

2567: dd.deprn_source_code;
2568: END IF;
2569:
2570: -- run only if CRL installed
2571: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2572:
2573: -- Get the Group Depreciation Effects
2574:
2575: IF (h_reporting_flag = 'R') THEN

Line 2724: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

2720: l_request_id);
2721:
2722: -- run only if CRL installed
2723:
2724: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2725: get_balance_group_begin(book,
2726: distribution_source_book,
2727: period1_pc - 1,
2728: period1_pc - 1,

Line 2760: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

2756: end_asset_id,
2757: l_request_id);
2758:
2759: -- run only if CRL installed
2760: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2761: get_balance_group_end(book,
2762: distribution_source_book,
2763: period2_pc,
2764: period1_pc - 1,

Line 2786: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN

2782: end_asset_id,
2783: l_request_id);
2784:
2785: -- run only if CRL installed
2786: IF (nvl(fnd_profile.value('CRL-FA ENABLED'), 'N') = 'Y') THEN
2787: get_adjustments_for_group(book,
2788: distribution_source_book,
2789: period1_pc,
2790: period2_pc,