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

Line 1496: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) --l_pay_value

1492: ,p_action_information12 => NULL
1493: ,p_action_information13 => NULL
1494: ,p_action_information14 => NULL
1495: ,p_action_information15 => NULL
1496: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) --l_pay_value
1497: ,p_action_information17 => NULL
1498: ,p_action_information18 => rec_pers_pay.opm_name
1499: ,p_assignment_id => p_assignment_id);
1500: ELSE

Line 1525: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) --l_pay_value

1521: ,p_action_information12 => NULL
1522: ,p_action_information13 => NULL
1523: ,p_action_information14 => NULL
1524: ,p_action_information15 => NULL
1525: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) --l_pay_value
1526: ,p_action_information17 => NULL
1527: ,p_action_information18 => rec_pers_pay.opm_name
1528: ,p_assignment_id => p_assignment_id);
1529: END IF;

Line 1561: ,p_action_information16 => fnd_number.number_to_canonical(rec_org_pay.value) --l_pay_value

1557: ,p_action_information12 => NULL
1558: ,p_action_information13 => NULL
1559: ,p_action_information14 => NULL
1560: ,p_action_information15 => NULL
1561: ,p_action_information16 => fnd_number.number_to_canonical(rec_org_pay.value) --l_pay_value
1562: ,p_action_information17 => NULL
1563: ,p_action_information18 => rec_org_pay.opm_name
1564: ,p_assignment_id => p_assignment_id);
1565: END LOOP;

Line 1881: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

1877: ,p_action_information_category => 'EMEA ELEMENT INFO'
1878: ,p_action_information1 => g_element_table(l_index).element_type_id
1879: ,p_action_information2 => g_element_table(l_index).input_value_id
1880: ,p_action_information3 => g_element_table(l_index).element_type
1881: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1882: ,p_action_information8 => csr_result_rec.record_count
1883: ,p_action_information9 => 'Additional Element unit per price :'||csr_result_rec.UNIT_PRICE
1884: ,p_assignment_id => p_assignment_id);
1885:

Line 1892: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(csr_result_rec.result_value));

1888: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
1889: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
1890: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
1891: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
1892: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(csr_result_rec.result_value));
1893: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
1894: END IF;
1895: END LOOP;*/
1896:

Line 1928: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

1924: ,p_action_information_category => 'EMEA ELEMENT INFO'
1925: ,p_action_information1 => g_element_table(l_index).element_type_id
1926: ,p_action_information2 => g_element_table(l_index).input_value_id
1927: ,p_action_information3 => g_element_table(l_index).element_type
1928: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1929: ,p_action_information8 => ''
1930: ,p_action_information9 => 'Additional Element:'
1931: ,p_assignment_id => p_assignment_id);
1932:

Line 1937: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

1933: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
1934: --fnd_file.put_line(fnd_file.log,'Earning Element ');
1935: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
1936: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
1937: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
1938: END IF;
1939: END LOOP;
1940:
1941: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

Line 1962: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

1958: ,p_action_information_category => 'EMEA ELEMENT INFO'
1959: ,p_action_information1 => g_element_table(l_index).element_type_id
1960: ,p_action_information2 => g_element_table(l_index).input_value_id
1961: ,p_action_information3 => g_element_table(l_index).element_type
1962: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1963: ,p_action_information8 => csr_result_rec.record_count
1964: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
1965: ,p_assignment_id => p_assignment_id);
1966:

Line 1971: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

1967: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
1968: --fnd_file.put_line(fnd_file.log,'Earning Element ');
1969: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
1970: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
1971: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
1972: END IF;
1973: END LOOP;
1974: END IF;
1975: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

Line 2010: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

2006: ,p_action_information_category => 'EMEA ELEMENT INFO'
2007: ,p_action_information1 => g_element_table(l_index).element_type_id
2008: ,p_action_information2 => g_element_table(l_index).input_value_id
2009: ,p_action_information3 => g_element_table(l_index).element_type
2010: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
2011: ,p_action_information8 => csr_result_rec.UNIT
2012: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2013: ,p_assignment_id => p_assignment_id);
2014:

Line 2019: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

2015: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2016: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2017: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
2018: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
2019: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
2020: END IF;
2021: END LOOP;
2022: ELSE
2023: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

Line 2042: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

2038: ,p_action_information_category => 'EMEA ELEMENT INFO'
2039: ,p_action_information1 => g_element_table(l_index).element_type_id
2040: ,p_action_information2 => g_element_table(l_index).input_value_id
2041: ,p_action_information3 => g_element_table(l_index).element_type
2042: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
2043: ,p_action_information8 => csr_result_rec.UNIT
2044: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2045: ,p_assignment_id => p_assignment_id);
2046:

Line 2051: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

2047: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2048: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2049: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
2050: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
2051: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
2052: END IF;
2053: END LOOP;
2054:
2055: END IF;-- end of rec_group_by.ORG_INFORMATION10 = 'Y'

Line 2111: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value

2107: ,p_action_information_category => 'EMEA ELEMENT INFO'
2108: ,p_action_information1 => g_element_table(l_index).element_type_id
2109: ,p_action_information2 => g_element_table(l_index).input_value_id
2110: ,p_action_information3 => g_element_table(l_index).element_type
2111: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
2112: ,p_action_information8 => l_unit
2113: ,p_action_information9 => 'Additional Element unit per price:'||l_uNIT_PRICE
2114: ,p_assignment_id => p_assignment_id);
2115:

Line 2120: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

2116: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2117: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2118: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
2119: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
2120: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
2121: END IF; -- end of csr_result_rec.result_value is not null
2122: END LOOP;
2123: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
2124:

Line 2162: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

2158: ,p_action_information_category => 'EMEA ELEMENT INFO'
2159: ,p_action_information1 => g_element_table(l_index).element_type_id
2160: ,p_action_information2 => g_element_table(l_index).input_value_id
2161: ,p_action_information3 => g_element_table(l_index).element_type
2162: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
2163: ,p_action_information8 => '1'
2164: ,p_action_information9 => 'Additional Element unit per price :'||l_unit_price
2165: ,p_assignment_id => p_assignment_id);
2166:

Line 2173: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(csr_result_rec.result_value));

2169: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2170: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
2171: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
2172: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
2173: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(csr_result_rec.result_value));
2174: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
2175:
2176: END IF;
2177: END LOOP;

Line 2200: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value

2196: ,p_action_information_category => 'EMEA ELEMENT INFO'
2197: ,p_action_information1 => g_element_table(l_index).element_type_id
2198: ,p_action_information2 => g_element_table(l_index).input_value_id
2199: ,p_action_information3 => g_element_table(l_index).element_type
2200: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value
2201: ,p_action_information8 => rec_sum_of_result_values.record_count
2202: ,p_action_information9 => 'Additional Element unit per price :'||l_unit_price
2203: ,p_assignment_id => p_assignment_id);
2204:

Line 2211: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(l_result_value));

2207: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2208: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
2209: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
2210: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
2211: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(l_result_value));
2212: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
2213: END IF;
2214: l_group_by :=NULL;
2215: END IF;-- End of l_group_by

Line 2321: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value) --l_formatted_value

2317: ,p_source_text => NULL
2318: ,p_action_information_category => 'EMEA BALANCES'
2319: ,p_action_information1 => g_user_balance_table(l_index).defined_balance_id
2320: ,p_action_information2 => 'OBAL' --Other Balances Context
2321: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value) --l_formatted_value
2322: ,p_action_information5 => NULL
2323: ,p_action_information6 => 'Other Balances'
2324: ,p_assignment_id => p_assignment_id);
2325:

Line 2329: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_balance_value) '||fnd_number.number_to_canonical(l_balance_value));

2325:
2326: --fnd_file.put_line(fnd_file.log,' Other Balances ');
2327: --fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2328: --fnd_file.put_line(fnd_file.log,' g_user_balance_table(l_index).defined_balance_id '||g_user_balance_table(l_index).defined_balance_id);
2329: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_balance_value) '||fnd_number.number_to_canonical(l_balance_value));
2330:
2331:
2332: END IF;
2333: END LOOP;

Line 2537: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)

2533: ,p_source_text => NULL
2534: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
2535: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2536: ,p_action_information5 => l_tax_card_type
2537: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)

Line 2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)

2534: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
2535: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2536: ,p_action_information5 => l_tax_card_type
2537: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)

Line 2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)

2535: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2536: ,p_action_information5 => l_tax_card_type
2537: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2543: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)

Line 2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)

2537: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2543: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2544: ,p_assignment_id => p_assignment_id);
2545:

Line 2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)

2538: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2543: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2544: ,p_assignment_id => p_assignment_id);
2545:
2546: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);

Line 2543: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)

2539: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2540: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2541: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2542: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2543: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2544: ,p_assignment_id => p_assignment_id);
2545:
2546: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2547: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);

Line 2550: -- fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_base_rate) '||fnd_number.number_to_canonical(l_Tax_Percentage));

2546: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2547: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2548: --fnd_file.put_line(fnd_file.log,' l_actual_termination_date '||l_actual_termination_date);
2549: -- fnd_file.put_line(fnd_file.log,' l_tax_card_type '||l_tax_card_type);
2550: -- fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_base_rate) '||fnd_number.number_to_canonical(l_Tax_Percentage));
2551:
2552: -- removed Say Certificate
2553:
2554: -- fnd_file.put_line(fnd_file.log,' Leaving Addl Employee details');

Line 3116: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3112: ,p_action_information_category => 'EMEA ELEMENT INFO'
3113: ,p_action_information1 => csr_rec.element_type_id
3114: ,p_action_information2 => csr_rec.input_value_id
3115: ,p_action_information3 => 'E'
3116: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3117: ,p_action_information8 => ''
3118: ,p_action_information9 => 'Earning Element:'
3119: ,p_assignment_id => p_assignment_id);
3120:

Line 3125: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3121: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3122: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3123: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3124: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3125: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3126: END IF;
3127: END LOOP;
3128:
3129: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

Line 3150: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3146: ,p_action_information_category => 'EMEA ELEMENT INFO'
3147: ,p_action_information1 => csr_rec.element_type_id
3148: ,p_action_information2 => csr_rec.input_value_id
3149: ,p_action_information3 => 'E'
3150: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3151: ,p_action_information8 => csr_result_rec.record_count
3152: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3153: ,p_assignment_id => p_assignment_id);
3154:

Line 3159: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3155: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3156: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3157: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3158: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3159: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3160: END IF;
3161: END LOOP;
3162: END IF;
3163: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

Line 3199: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

3195: ,p_action_information_category => 'EMEA ELEMENT INFO'
3196: ,p_action_information1 => csr_rec.element_type_id
3197: ,p_action_information2 => csr_rec.input_value_id
3198: ,p_action_information3 => 'E'
3199: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3200: ,p_action_information8 => csr_result_rec.UNIT
3201: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3202: ,p_assignment_id => p_assignment_id);
3203:

Line 3208: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

3204: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3205: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3206: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3207: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3208: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3209: END IF;
3210: END LOOP;
3211: ELSE
3212: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

Line 3231: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

3227: ,p_action_information_category => 'EMEA ELEMENT INFO'
3228: ,p_action_information1 => csr_rec.element_type_id
3229: ,p_action_information2 => csr_rec.input_value_id
3230: ,p_action_information3 => 'E'
3231: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3232: ,p_action_information8 => csr_result_rec.UNIT
3233: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3234: ,p_assignment_id => p_assignment_id);
3235:

Line 3240: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

3236: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3237: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3238: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3239: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3240: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3241: END IF; -- end of csr_result_rec.AMOUNT is not null
3242: END LOOP;
3243:
3244: END IF; -- end of rec_group_by.ORG_INFORMATION10 = 'Y'

Line 3300: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value

3296: ,p_action_information_category => 'EMEA ELEMENT INFO'
3297: ,p_action_information1 => csr_rec.element_type_id
3298: ,p_action_information2 => csr_rec.input_value_id
3299: ,p_action_information3 => 'E'
3300: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
3301: ,p_action_information8 => l_unit
3302: ,p_action_information9 => 'Earning Element unit per price:'||l_uNIT_PRICE
3303: ,p_assignment_id => p_assignment_id);
3304:

Line 3309: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3305: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3306: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3307: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3308: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3309: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3310: END IF; -- end of csr_result_rec.result_value is not null
3311: END LOOP;
3312: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
3313:

Line 3336: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3332: ,p_action_information_category => 'EMEA ELEMENT INFO'
3333: ,p_action_information1 => csr_rec.element_type_id
3334: ,p_action_information2 => csr_rec.input_value_id
3335: ,p_action_information3 => 'E'
3336: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3337: ,p_action_information8 => csr_result_rec.record_count
3338: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3339: ,p_assignment_id => p_assignment_id);
3340:

Line 3345: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3341: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3342: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3343: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3344: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3345: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3346: END IF;
3347: END LOOP;
3348: */
3349: --OPEN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id);

Line 3372: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3368: ,p_action_information_category => 'EMEA ELEMENT INFO'
3369: ,p_action_information1 => csr_rec.element_type_id
3370: ,p_action_information2 => csr_rec.input_value_id
3371: ,p_action_information3 => 'E'
3372: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3373: --,p_action_information5 => csr_rec.element_code
3374: ,p_action_information9 => 'Earning Element'
3375: ,p_assignment_id => p_assignment_id);
3376:

Line 3381: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3377: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3378: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3379: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3380: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3381: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3382: END IF;
3383: END LOOP;
3384: --l_group_by :=NULL;
3385: --ELSE

Line 3405: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value

3401: ,p_action_information_category => 'EMEA ELEMENT INFO'
3402: ,p_action_information1 => csr_rec.element_type_id
3403: ,p_action_information2 => csr_rec.input_value_id
3404: ,p_action_information3 => 'E'
3405: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value
3406: --,p_action_information5 => csr_rec.element_code
3407: ,p_action_information9 => 'Earning Element'
3408: ,p_assignment_id => p_assignment_id);
3409:

Line 3414: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(l_result_value) );

3410: --fnd_file.put_line(fnd_file.log,'GROUP BY YES l_action_info_id ' || l_action_info_id );
3411: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3412: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3413: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3414: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(l_result_value) );
3415: END IF;
3416: l_group_by :=NULL;
3417: END IF; -- end if for the l_group_by*/
3418:

Line 3476: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3472: ,p_action_information_category => 'EMEA ELEMENT INFO'
3473: ,p_action_information1 => csr_rec.element_type_id
3474: ,p_action_information2 => csr_rec.input_value_id
3475: ,p_action_information3 => 'D'
3476: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3477: ,p_action_information8 => ''
3478: ,p_action_information9 => 'Deduction Element:'
3479: ,p_assignment_id => p_assignment_id);
3480:

Line 3485: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3481: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3482: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3483: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3484: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3485: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3486: END IF;
3487: END LOOP;
3488:
3489: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

Line 3510: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3506: ,p_action_information_category => 'EMEA ELEMENT INFO'
3507: ,p_action_information1 => csr_rec.element_type_id
3508: ,p_action_information2 => csr_rec.input_value_id
3509: ,p_action_information3 => 'D'
3510: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3511: ,p_action_information8 => csr_result_rec.record_count
3512: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3513: ,p_assignment_id => p_assignment_id);
3514:

Line 3519: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3515: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3516: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3517: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3518: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3519: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3520: END IF;
3521: END LOOP;
3522: END IF;
3523: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

Line 3557: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

3553: ,p_action_information_category => 'EMEA ELEMENT INFO'
3554: ,p_action_information1 => csr_rec.element_type_id
3555: ,p_action_information2 => csr_rec.input_value_id
3556: ,p_action_information3 => 'D'
3557: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3558: ,p_action_information8 => csr_result_rec.UNIT
3559: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3560: ,p_assignment_id => p_assignment_id);
3561:

Line 3566: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

3562: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3563: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3564: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3565: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3566: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3567: END IF;
3568: END LOOP;
3569: ELSE
3570: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

Line 3589: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value

3585: ,p_action_information_category => 'EMEA ELEMENT INFO'
3586: ,p_action_information1 => csr_rec.element_type_id
3587: ,p_action_information2 => csr_rec.input_value_id
3588: ,p_action_information3 => 'D'
3589: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3590: ,p_action_information8 => csr_result_rec.UNIT
3591: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3592: ,p_assignment_id => p_assignment_id);
3593:

Line 3598: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );

3594: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3595: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3596: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3597: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3598: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3599: END IF;
3600: END LOOP;
3601:
3602: END IF;-- end of rec_group_by.ORG_INFORMATION10 = 'Y'

Line 3657: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value

3653: ,p_action_information_category => 'EMEA ELEMENT INFO'
3654: ,p_action_information1 => csr_rec.element_type_id
3655: ,p_action_information2 => csr_rec.input_value_id
3656: ,p_action_information3 => 'D'
3657: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
3658: ,p_action_information8 => l_unit
3659: ,p_action_information9 => 'Deduction Element unit per price:'||l_uNIT_PRICE
3660: ,p_assignment_id => p_assignment_id);
3661:

Line 3666: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );

3662: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3663: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3664: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3665: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3666: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.result_value) );
3667: END IF; -- end of csr_result_rec.result_value is not null
3668: END LOOP;
3669: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
3670: END IF;

Line 3695: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3691: ,p_action_information_category => 'EMEA ELEMENT INFO'
3692: ,p_action_information1 => csr_rec.element_type_id
3693: ,p_action_information2 => csr_rec.input_value_id
3694: ,p_action_information3 => 'D'
3695: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3696: ,p_action_information8 => csr_result_rec.record_count
3697: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3698: ,p_assignment_id => p_assignment_id);
3699: END IF;

Line 3723: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value

3719: ,p_action_information_category => 'EMEA ELEMENT INFO'
3720: ,p_action_information1 => csr_rec.element_type_id
3721: ,p_action_information2 => csr_rec.input_value_id
3722: ,p_action_information3 => 'D'
3723: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3724: --,p_action_information5 => csr_rec.element_code
3725: ,p_action_information9 => 'Deduction Element'
3726: ,p_assignment_id => p_assignment_id);
3727: