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_IE_LEGISLATIVE_ARCHIVE dependencies on FND_NUMBER

Line 126: -- SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value

122: p_element_type_3 IN VARCHAR) IS
123:
124: SELECT /*+ leading(lck,paa2) */ lck.locking_action_id ACTION_CONTEXT_ID, pet.element_type_id, piv.input_value_id, pai.action_information4 NARRATIVE,
125: nvl (pet.reporting_name ,pet.element_name),pai.action_information5 PAYMENT_TYPE,
126: -- SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value
127: decode (nvl (pet.reporting_name
128: ,pet.element_name)
129: ,'BIK Arrearage'
130: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))

Line 130: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))

126: -- SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) value, SUM(FND_NUMBER.CANONICAL_TO_NUMBER(prv.result_value)) numeric_value
127: decode (nvl (pet.reporting_name
128: ,pet.element_name)
129: ,'BIK Arrearage'
130: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
131: ,sum (fnd_number.canonical_to_number (prv.result_value))) value,
132: decode (nvl (pet.reporting_name
133: ,pet.element_name)
134: ,'BIK Arrearage'

Line 131: ,sum (fnd_number.canonical_to_number (prv.result_value))) value,

127: decode (nvl (pet.reporting_name
128: ,pet.element_name)
129: ,'BIK Arrearage'
130: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
131: ,sum (fnd_number.canonical_to_number (prv.result_value))) value,
132: decode (nvl (pet.reporting_name
133: ,pet.element_name)
134: ,'BIK Arrearage'
135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))

Line 135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))

131: ,sum (fnd_number.canonical_to_number (prv.result_value))) value,
132: decode (nvl (pet.reporting_name
133: ,pet.element_name)
134: ,'BIK Arrearage'
135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value
137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action

Line 136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value

132: decode (nvl (pet.reporting_name
133: ,pet.element_name)
134: ,'BIK Arrearage'
135: ,sum (fnd_number.canonical_to_number (prv.result_value * (- 1)))
136: ,sum (fnd_number.canonical_to_number (prv.result_value))) numeric_value
137: FROM pay_action_interlocks lck, -- archive action locking prepayment
138: pay_assignment_actions paa1, -- prepayment action
139: pay_assignment_actions paa2, -- archive action
140: pay_payroll_actions ppa, -- prepayment

Line 245: , p_action_information4 => FND_NUMBER.CANONICAL_TO_NUMBER(rec_element_value.value)

241: , p_action_information_category => 'EMEA ELEMENT INFO'
242: , p_action_information1 => rec_element_value.element_type_id
243: , p_action_information2 => rec_element_value.input_value_id
244: , p_action_information3 => rec_element_value.payment_type
245: , p_action_information4 => FND_NUMBER.CANONICAL_TO_NUMBER(rec_element_value.value)
246: , p_action_information5 => rec_element_value.narrative
247: , p_effective_date => l_effective_date
248: , p_assignment_id => l_assignment_id
249: );

Line 1689: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Changed by rmakhija for 3574741

1685: , p_action_information_category => 'EMEA BALANCES'
1686: , p_action_information1 => p_defined_bal_id
1687: , p_action_information2 => NULL
1688: , p_action_information3 => NULL
1689: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Changed by rmakhija for 3574741
1690: , p_action_information5 => l_record_count);
1691:
1692: END IF;
1693:

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

1746: AND prt.run_method IN ('N','P')
1747: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
1748: AND paa1.assignment_action_id IN
1749: (SELECT /*+ USE_NL(paa, ppa) */
1750: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
1751: paa.assignment_action_id),16)) child_assignment_action_id
1752: FROM pay_assignment_actions paa,
1753: pay_payroll_actions ppa
1754: WHERE paa.assignment_id = p_assignment_id

Line 1755: AND fnd_number.canonical_to_number(substr(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id,16)) <> p_child_asg_act_id

1751: paa.assignment_action_id),16)) child_assignment_action_id
1752: FROM pay_assignment_actions paa,
1753: pay_payroll_actions ppa
1754: WHERE paa.assignment_id = p_assignment_id
1755: AND fnd_number.canonical_to_number(substr(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id,16)) <> p_child_asg_act_id
1756: AND ppa.payroll_action_id = paa.payroll_action_id
1757: AND (paa.source_action_id is not null or ppa.action_type in ('I','V'))
1758: AND ppa.effective_date between trunc(p_effective_date,'Y') and p_effective_date
1759: AND ppa.action_type in ('R', 'Q', 'I', 'V')

Line 1875: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),

1871: ELSE
1872: -- Added for bug 5387406. This checks for UOM, if it is money set the
1873: -- format mask to '999999999999999990.00'
1874: SELECT decode(g_element_table(l_index).uom, 'M',
1875: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1876: rec_element_value.result_value)
1877: INTO l_result_value
1878: FROM dual;
1879:

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

2770: WHERE paa.run_type_id = prt.run_type_id
2771: AND prt.run_method = 'S'
2772: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2773: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2774: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2775: paa.assignment_action_id),16)) child_assignment_action_id
2776: FROM pay_assignment_actions paa,
2777: pay_payroll_actions ppa
2778: WHERE paa.assignment_id = p_assignment_id

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

2790: WHERE paa.run_type_id = prt.run_type_id
2791: AND prt.run_method IN ('N','P')
2792: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2793: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2794: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2795: paa.assignment_action_id),16)) child_assignment_action_id
2796: FROM pay_assignment_actions paa,
2797: pay_payroll_actions ppa
2798: WHERE paa.assignment_id = p_assignment_id

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

2830: WHERE paa.run_type_id = prt.run_type_id
2831: AND prt.run_method IN ('N','P')
2832: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2833: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2834: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2835: paa.assignment_action_id),16))
2836: FROM pay_assignment_actions paa,
2837: pay_payroll_actions ppa
2838: WHERE paa.assignment_id = p_assignment_id