eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on FND_NUMBER

Line 1524: l_text := 'SELECT /+ RULE/ fnd_number.number_to_canonical(' ||

1520: end if;
1521: end if;
1522:
1523: if (g_low_volume = 'Y') then
1524: l_text := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1525: l_definition_text || ') FROM ' || l_text;
1526: else
1527: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1528: l_definition_text || ') FROM ' || l_text;

Line 1527: l_text := 'SELECT fnd_number.number_to_canonical(' ||

1523: if (g_low_volume = 'Y') then
1524: l_text := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1525: l_definition_text || ') FROM ' || l_text;
1526: else
1527: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1528: l_definition_text || ') FROM ' || l_text;
1529: end if;
1530: else
1531: -- Not a balance dbitem

Line 1532: l_text := 'SELECT fnd_number.number_to_canonical(' ||

1528: l_definition_text || ') FROM ' || l_text;
1529: end if;
1530: else
1531: -- Not a balance dbitem
1532: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1533: l_definition_text || ') FROM ' || l_text;
1534: end if;
1535: else -- Optimiser hint has bee supplied
1536: l_text := 'SELECT /*+ '||l_o_hint||

Line 1537: ' */ fnd_number.number_to_canonical(' ||

1533: l_definition_text || ') FROM ' || l_text;
1534: end if;
1535: else -- Optimiser hint has bee supplied
1536: l_text := 'SELECT /*+ '||l_o_hint||
1537: ' */ fnd_number.number_to_canonical(' ||
1538: l_definition_text || ') FROM ' || l_text;
1539: end if;
1540: --
1541: else

Line 1757: l_select_clause := 'nvl(sum(fnd_number.canonical_to_number('||l_select_clause||') * FEED.scale),0)';

1753: else
1754: l_select_clause := p_retrieval_column;
1755: end if;
1756: --
1757: l_select_clause := 'nvl(sum(fnd_number.canonical_to_number('||l_select_clause||') * FEED.scale),0)';
1758: l_from_clause := ' FROM '||p_from_clause;
1759: --
1760: -- Setup the Select and optimiser
1761: --

Line 1764: l_select_clause := 'SELECT /+ RULE/ fnd_number.number_to_canonical(' ||

1760: -- Setup the Select and optimiser
1761: --
1762: if (p_o_hint is null) then
1763: if (g_low_volume = 'Y') then
1764: l_select_clause := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1765: l_select_clause || ')';
1766: else
1767: l_select_clause := 'SELECT fnd_number.number_to_canonical(' ||
1768: l_select_clause || ')';

Line 1767: l_select_clause := 'SELECT fnd_number.number_to_canonical(' ||

1763: if (g_low_volume = 'Y') then
1764: l_select_clause := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1765: l_select_clause || ')';
1766: else
1767: l_select_clause := 'SELECT fnd_number.number_to_canonical(' ||
1768: l_select_clause || ')';
1769: end if;
1770: else
1771: l_select_clause := 'SELECT /*+ '||p_o_hint||

Line 1772: ' */ fnd_number.number_to_canonical(' ||

1768: l_select_clause || ')';
1769: end if;
1770: else
1771: l_select_clause := 'SELECT /*+ '||p_o_hint||
1772: ' */ fnd_number.number_to_canonical(' ||
1773: l_select_clause || ')';
1774: end if;
1775: --
1776: -- if g_debug then

Line 2046: p_balance_value := fnd_number.canonical_to_number(l_temp);

2042: else
2043: execute immediate p_statement into l_temp using p_balance_type_id, l_assact_id;
2044: end if;
2045:
2046: p_balance_value := fnd_number.canonical_to_number(l_temp);
2047:
2048: --For Bug 14666688 : end
2049:
2050: if g_debug then

Line 2196: fnd_number.canonical_to_number(l_db_output);

2192: --
2193: for cnt in p_batch_str_ptr..p_batch_end_ptr loop
2194: if (p_balance_list(cnt).balance_type_id = l_balance_type_id) then
2195: p_balance_list(cnt).balance_value :=
2196: fnd_number.canonical_to_number(l_db_output);
2197: if g_debug then
2198: hr_utility.trace('****Bal = '||l_balance_type_id||' Value = '||
2199: l_db_output);
2200: end if;

Line 2222: p_balance_value := fnd_number.canonical_to_number(l_db_output);

2218: end if;
2219: if g_debug then
2220: hr_utility.trace('process_balance_statement Value = '||l_db_output);
2221: end if;
2222: p_balance_value := fnd_number.canonical_to_number(l_db_output);
2223: --
2224: end if;
2225: --
2226: l_value_retrieved := TRUE;

Line 3185: l_balance_value := fnd_number.canonical_to_number(run_db_item(p_defined_balance_id));

3181: else
3182: if g_debug then
3183: hr_utility.set_location ('Entering: pay_balance_pkg.get_rr_value', 30);
3184: end if;
3185: l_balance_value := fnd_number.canonical_to_number(run_db_item(p_defined_balance_id));
3186: end if;
3187: end if;
3188: --
3189: -- Setup the return values

Line 5972: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'

5968: --
5969: cursor get_latest_id (c_assignment_id IN NUMBER,
5970: c_effective_date IN DATE) is
5971: SELECT /*+ ORDERED USE_NL(paa,ppa) */
5972: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'
5973: 0')||
5974: paa.assignment_action_id),16))
5975: FROM pay_assignment_actions paa,
5976: pay_payroll_actions ppa

Line 5986: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

5982: --
5983: cursor get_per_latest_id (c_assignment_id IN NUMBER,
5984: c_effective_date IN DATE) is
5985: SELECT /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_PK) */
5986: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5987: paa.assignment_action_id),16))
5988: FROM pay_assignment_actions paa,
5989: pay_payroll_actions ppa,
5990: (SELECT DISTINCT paf2.assignment_id

Line 11435: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value

11431: INDEX(rr PAY_RUN_RESULTS_N50)
11432: */
11433: assact.assignment_action_id,
11434: count(1) feed_count,
11435: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value
11436: from
11437: pay_assignment_actions assact,
11438: pay_payroll_actions pact,
11439: pay_run_results rr,

Line 11541: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run

11537: INDEX(rr PAY_RUN_RESULTS_N50)
11538: */
11539: assact.assignment_action_id,
11540: count(1) feed_count,
11541: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11542: bulk collect into g_asg_actions_tab
11543: from
11544: pay_assignment_actions assact,
11545: pay_payroll_actions pact,

Line 11735: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value

11731: INDEX(rr PAY_RUN_RESULTS_N50)
11732: */
11733: assact.assignment_action_id,
11734: count(1) feed_count,
11735: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * p_scale), 0) value
11736: from
11737: pay_assignment_actions gen_assact,
11738: pay_assignment_actions assact,
11739: pay_payroll_actions pact,

Line 11845: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run

11841: INDEX(rr PAY_RUN_RESULTS_N50)
11842: */
11843: assact.assignment_action_id,
11844: count(1) feed_count,
11845: nvl(sum(fnd_number.canonical_to_number(rrv.result_value) * FEED.scale), 0) asg_run
11846: bulk collect into g_asg_actions_tab
11847: from
11848: pay_assignment_actions gen_assact,
11849: pay_assignment_actions assact,