APPS.XLA_BALANCES_CALC_PKG dependencies on FND_PROFILE

Line 712: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

708:
709: l_summary_bind_count := l_summary_bind_count-1;
710:
711: -- Replace perf. hint dynamically
712: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
713: l_summary_stmt := REPLACE(l_summary_stmt,'$parallel$','parallel(aeh)');
714: ELSE
715: l_summary_stmt := REPLACE(l_summary_stmt,'$parallel$','');
716: END IF;

Line 1145: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

1141: , xal_bal1.effective_period_num
1142: FROM xla_ac_bal_interim_gt xal_bal1)';
1143:
1144: -- Replace parallel hint based on the profile option
1145: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
1146: l_update_bal := REPLACE(l_update_bal,'$parallel$','parallel(tmp)');
1147: l_update_bal := REPLACE(l_update_bal,'$parallel_1$','parallel(xal_bal1)');
1148: ELSE
1149: l_update_bal := REPLACE(l_update_bal,'$parallel$','');

Line 1304: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

1300: AND NVL (xba.ac5, '' '') = NVL (temp.ac5, '' '')
1301: AND xba.period_name = gps.period_name)';
1302:
1303: -- Replace parallel hint based on profile option
1304: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
1305: l_insert_bal := REPLACE(l_insert_bal,'$parallel$','parallel(temp)');
1306: l_insert_bal := REPLACE(l_insert_bal,'$parallel_1$','parallel(xba)');
1307: ELSE
1308: l_insert_bal := REPLACE(l_insert_bal,'$parallel$','');

Line 1474: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

1470:
1471: l_update_processed := l_update_processed||')';
1472:
1473: -- Replace parallel hint based on the profile option
1474: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
1475: l_update_processed := REPLACE(l_update_processed,'$parallel$','parallel(aeh)');
1476: ELSE
1477: l_update_processed := REPLACE(l_update_processed,'$parallel$','');
1478: END IF;

Line 1829: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

1825:
1826: l_summary_bind_count := l_summary_bind_count-1;
1827:
1828: -- Replace perf. hint dynamically
1829: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
1830: l_summary_stmt := REPLACE(l_summary_stmt,'$parallel$','parallel(aeh)');
1831: ELSE
1832: l_summary_stmt := REPLACE(l_summary_stmt,'$parallel$','');
1833: END IF;

Line 2152: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

2148: , xal_bal1.effective_period_num
2149: FROM xla_ctrl_bal_interim_gt xal_bal1)';
2150:
2151: -- Replace parallel hint based on the profile option
2152: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
2153: l_update_bal := REPLACE(l_update_bal,'$parallel$','parallel(tmp)');
2154: l_update_bal := REPLACE(l_update_bal,'$parallel_1$','parallel(xal_bal1)');
2155: ELSE
2156: l_update_bal := REPLACE(l_update_bal,'$parallel$','');

Line 2280: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

2276: AND xba.party_site_id = temp.party_site_id
2277: AND xba.period_name = temp.period_name)';
2278:
2279: -- Replace parallel hint based on profile option
2280: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
2281: l_insert_bal := REPLACE(l_insert_bal,'$parallel$','parallel(temp)');
2282: l_insert_bal := REPLACE(l_insert_bal,'$parallel_1$','parallel(xba)');
2283: ELSE
2284: l_insert_bal := REPLACE(l_insert_bal,'$parallel$','');

Line 2443: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN

2439:
2440: l_update_processed := l_update_processed||')';
2441:
2442: -- Replace parallel hint based on the profile option
2443: IF (nvl(fnd_profile.value('XLA_BAL_PARALLEL_MODE'),'N') ='Y') THEN
2444: l_update_processed := REPLACE(l_update_processed,'$parallel$','parallel(aeh)');
2445: ELSE
2446: l_update_processed := REPLACE(l_update_processed,'$parallel$','');
2447: END IF;