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 1437: l_text := 'SELECT /+ RULE/ fnd_number.number_to_canonical(' ||

1433: end if;
1434: end if;
1435:
1436: if (g_low_volume = 'Y') then
1437: l_text := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1438: l_definition_text || ') FROM ' || l_text;
1439: else
1440: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1441: l_definition_text || ') FROM ' || l_text;

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

1436: if (g_low_volume = 'Y') then
1437: l_text := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1438: l_definition_text || ') FROM ' || l_text;
1439: else
1440: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1441: l_definition_text || ') FROM ' || l_text;
1442: end if;
1443: else
1444: -- Not a balance dbitem

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

1441: l_definition_text || ') FROM ' || l_text;
1442: end if;
1443: else
1444: -- Not a balance dbitem
1445: l_text := 'SELECT fnd_number.number_to_canonical(' ||
1446: l_definition_text || ') FROM ' || l_text;
1447: end if;
1448: else -- Optimiser hint has bee supplied
1449: l_text := 'SELECT /*+ '||l_o_hint||

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

1446: l_definition_text || ') FROM ' || l_text;
1447: end if;
1448: else -- Optimiser hint has bee supplied
1449: l_text := 'SELECT /*+ '||l_o_hint||
1450: ' */ fnd_number.number_to_canonical(' ||
1451: l_definition_text || ') FROM ' || l_text;
1452: end if;
1453: --
1454: else

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

1665: else
1666: l_select_clause := p_retrieval_column;
1667: end if;
1668: --
1669: l_select_clause := 'nvl(sum(fnd_number.canonical_to_number('||l_select_clause||') * FEED.scale),0)';
1670: l_from_clause := ' FROM '||p_from_clause;
1671: --
1672: -- Setup the Select and optimiser
1673: --

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

1672: -- Setup the Select and optimiser
1673: --
1674: if (p_o_hint is null) then
1675: if (g_low_volume = 'Y') then
1676: l_select_clause := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1677: l_select_clause || ')';
1678: else
1679: l_select_clause := 'SELECT fnd_number.number_to_canonical(' ||
1680: l_select_clause || ')';

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

1675: if (g_low_volume = 'Y') then
1676: l_select_clause := 'SELECT /*+ RULE*/ fnd_number.number_to_canonical(' ||
1677: l_select_clause || ')';
1678: else
1679: l_select_clause := 'SELECT fnd_number.number_to_canonical(' ||
1680: l_select_clause || ')';
1681: end if;
1682: else
1683: l_select_clause := 'SELECT /*+ '||p_o_hint||

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

1680: l_select_clause || ')';
1681: end if;
1682: else
1683: l_select_clause := 'SELECT /*+ '||p_o_hint||
1684: ' */ fnd_number.number_to_canonical(' ||
1685: l_select_clause || ')';
1686: end if;
1687: --
1688: if g_debug then

Line 2030: fnd_number.canonical_to_number(l_db_output);

2026: --
2027: for cnt in p_batch_str_ptr..p_batch_end_ptr loop
2028: if (p_balance_list(cnt).balance_type_id = l_balance_type_id) then
2029: p_balance_list(cnt).balance_value :=
2030: fnd_number.canonical_to_number(l_db_output);
2031: if g_debug then
2032: hr_utility.trace('****Bal = '||l_balance_type_id||' Value = '||
2033: l_db_output);
2034: end if;

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

2052: end if;
2053: if g_debug then
2054: hr_utility.trace('Value = '||l_db_output);
2055: end if;
2056: p_balance_value := fnd_number.canonical_to_number(l_db_output);
2057: --
2058: end if;
2059: --
2060: l_value_retrieved := TRUE;

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

2904: else
2905: if g_debug then
2906: hr_utility.set_location ('Entering: pay_balance_pkg.get_rr_value', 30);
2907: end if;
2908: l_balance_value := fnd_number.canonical_to_number(run_db_item(p_defined_balance_id));
2909: end if;
2910: end if;
2911: --
2912: -- Setup the return values

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

5666: --
5667: cursor get_latest_id (c_assignment_id IN NUMBER,
5668: c_effective_date IN DATE) is
5669: SELECT /*+ USE_NL(paa, ppa) */
5670: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'
5671: 0')||
5672: paa.assignment_action_id),16))
5673: FROM pay_assignment_actions paa,
5674: pay_payroll_actions ppa

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

5684: INDEX(PAF2 PER_ASSIGNMENTS_F_N12)
5685: INDEX(PAA PAY_ASSIGNMENT_ACTIONS_N51)
5686: INDEX(PPA PAY_PAYROLL_ACTIONS_PK)
5687: USE_NL(paa, ppa) */
5688: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
5689: paa.assignment_action_id),16))
5690: FROM pay_assignment_actions paa,
5691: pay_payroll_actions ppa,
5692: per_all_assignments_f paf1,