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 1498: ,p_action_information16 => fnd_number.number_to_canonical(rec_pers_pay.value) --l_pay_value

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

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

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

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

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

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

1889: ,p_action_information_category => 'EMEA ELEMENT INFO'
1890: ,p_action_information1 => g_element_table(l_index).element_type_id
1891: ,p_action_information2 => g_element_table(l_index).input_value_id
1892: ,p_action_information3 => g_element_table(l_index).element_type
1893: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1894: ,p_action_information8 => csr_result_rec.record_count
1895: ,p_action_information9 => 'Additional Element unit per price :'||csr_result_rec.UNIT_PRICE
1896: ,p_assignment_id => p_assignment_id);
1897:

Line 1904: --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));

1900: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
1901: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
1902: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
1903: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
1904: --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));
1905: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
1906: END IF;
1907: END LOOP;*/
1908:

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

1936: ,p_action_information_category => 'EMEA ELEMENT INFO'
1937: ,p_action_information1 => g_element_table(l_index).element_type_id
1938: ,p_action_information2 => g_element_table(l_index).input_value_id
1939: ,p_action_information3 => g_element_table(l_index).element_type
1940: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1941: ,p_action_information8 => ''
1942: ,p_action_information9 => 'Additional Element:'
1943: ,p_assignment_id => p_assignment_id);
1944:

Line 1949: --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) );

1945: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
1946: --fnd_file.put_line(fnd_file.log,'Earning Element ');
1947: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
1948: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
1949: --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) );
1950: END IF;
1951: END LOOP;
1952:
1953: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

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

1970: ,p_action_information_category => 'EMEA ELEMENT INFO'
1971: ,p_action_information1 => g_element_table(l_index).element_type_id
1972: ,p_action_information2 => g_element_table(l_index).input_value_id
1973: ,p_action_information3 => g_element_table(l_index).element_type
1974: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
1975: ,p_action_information8 => csr_result_rec.record_count
1976: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
1977: ,p_assignment_id => p_assignment_id);
1978:

Line 1983: --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) );

1979: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
1980: --fnd_file.put_line(fnd_file.log,'Earning Element ');
1981: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
1982: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
1983: --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) );
1984: END IF;
1985: END LOOP;
1986: END IF;
1987: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

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

2018: ,p_action_information_category => 'EMEA ELEMENT INFO'
2019: ,p_action_information1 => g_element_table(l_index).element_type_id
2020: ,p_action_information2 => g_element_table(l_index).input_value_id
2021: ,p_action_information3 => g_element_table(l_index).element_type
2022: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
2023: ,p_action_information8 => csr_result_rec.UNIT
2024: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2025: ,p_assignment_id => p_assignment_id);
2026:

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

2027: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2028: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2029: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
2030: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
2031: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
2032: END IF;
2033: END LOOP;
2034: ELSE
2035: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

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

2050: ,p_action_information_category => 'EMEA ELEMENT INFO'
2051: ,p_action_information1 => g_element_table(l_index).element_type_id
2052: ,p_action_information2 => g_element_table(l_index).input_value_id
2053: ,p_action_information3 => g_element_table(l_index).element_type
2054: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
2055: ,p_action_information8 => csr_result_rec.UNIT
2056: ,p_action_information9 => 'Additional Element unit per price:'||csr_result_rec.UNIT_PRICE
2057: ,p_assignment_id => p_assignment_id);
2058:

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

2059: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2060: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2061: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
2062: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
2063: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
2064: END IF;
2065: END LOOP;
2066:
2067: END IF;-- end of rec_group_by.ORG_INFORMATION10 = 'Y'

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

2119: ,p_action_information_category => 'EMEA ELEMENT INFO'
2120: ,p_action_information1 => g_element_table(l_index).element_type_id
2121: ,p_action_information2 => g_element_table(l_index).input_value_id
2122: ,p_action_information3 => g_element_table(l_index).element_type
2123: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
2124: ,p_action_information8 => l_unit
2125: ,p_action_information9 => 'Additional Element unit per price:'||l_uNIT_PRICE
2126: ,p_assignment_id => p_assignment_id);
2127:

Line 2132: --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) );

2128: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
2129: --fnd_file.put_line(fnd_file.log,'Earning Element ');
2130: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || g_element_table(l_index).element_type_id );
2131: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || g_element_table(l_index).input_value_id );
2132: --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) );
2133: END IF; -- end of csr_result_rec.result_value is not null
2134: END LOOP;
2135: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
2136:

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

2170: ,p_action_information_category => 'EMEA ELEMENT INFO'
2171: ,p_action_information1 => g_element_table(l_index).element_type_id
2172: ,p_action_information2 => g_element_table(l_index).input_value_id
2173: ,p_action_information3 => g_element_table(l_index).element_type
2174: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
2175: ,p_action_information8 => '1'
2176: ,p_action_information9 => 'Additional Element unit per price :'||l_unit_price
2177: ,p_assignment_id => p_assignment_id);
2178:

Line 2185: --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));

2181: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2182: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
2183: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
2184: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
2185: --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));
2186: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
2187:
2188: END IF;
2189: END LOOP;

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

2208: ,p_action_information_category => 'EMEA ELEMENT INFO'
2209: ,p_action_information1 => g_element_table(l_index).element_type_id
2210: ,p_action_information2 => g_element_table(l_index).input_value_id
2211: ,p_action_information3 => g_element_table(l_index).element_type
2212: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value
2213: ,p_action_information8 => rec_sum_of_result_values.record_count
2214: ,p_action_information9 => 'Additional Element unit per price :'||l_unit_price
2215: ,p_assignment_id => p_assignment_id);
2216:

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

2219: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2220: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type_id '||g_element_table(l_index).element_type_id);
2221: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).input_value_id '||g_element_table(l_index).input_value_id);
2222: --fnd_file.put_line(fnd_file.log,' g_element_table(l_index).element_type '||g_element_table(l_index).element_type);
2223: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_result_value) '||fnd_number.number_to_canonical(l_result_value));
2224: --fnd_file.put_line(fnd_file.log,' p_assignment_id '||p_assignment_id);
2225: END IF;
2226: l_group_by :=NULL;
2227: END IF;-- End of l_group_by

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

2329: ,p_source_text => NULL
2330: ,p_action_information_category => 'EMEA BALANCES'
2331: ,p_action_information1 => g_user_balance_table(l_index).defined_balance_id
2332: ,p_action_information2 => 'OBAL' --Other Balances Context
2333: ,p_action_information4 => fnd_number.number_to_canonical(l_balance_value) --l_formatted_value
2334: ,p_action_information5 => NULL
2335: ,p_action_information6 => 'Other Balances'
2336: ,p_assignment_id => p_assignment_id);
2337:

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

2337:
2338: --fnd_file.put_line(fnd_file.log,' Other Balances ');
2339: --fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2340: --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);
2341: --fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_balance_value) '||fnd_number.number_to_canonical(l_balance_value));
2342:
2343:
2344: END IF;
2345: END LOOP;

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

2545: ,p_source_text => NULL
2546: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
2547: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2548: ,p_action_information5 => l_tax_card_type
2549: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2550: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)

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

2546: ,p_action_information_category => 'ADDL EMPLOYEE DETAILS'
2547: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2548: ,p_action_information5 => l_tax_card_type
2549: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2550: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2554: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)

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

2547: ,p_action_information4 => fnd_date.date_to_displaydate(l_actual_termination_date)
2548: ,p_action_information5 => l_tax_card_type
2549: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2550: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2554: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2555: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)

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

2549: ,p_action_information6 => fnd_number.number_to_canonical(l_Tax_Percentage)
2550: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2554: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2555: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2556: ,p_assignment_id => p_assignment_id);
2557:

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

2550: ,p_action_information7 => fnd_number.number_to_canonical(l_Tax_Table_Number)
2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2554: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2555: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2556: ,p_assignment_id => p_assignment_id);
2557:
2558: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);

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

2551: ,p_action_information8 => fnd_number.number_to_canonical(l_Tax_Column)
2552: ,p_action_information9 => fnd_date.date_to_displaydate(l_tax_card_effective_date)
2553: ,p_action_information10 => fnd_number.number_to_canonical(l_Tax_Free_Threshold)
2554: ,p_action_information11 => fnd_number.number_to_canonical(l_Calculation_Code)
2555: ,p_action_information12 => fnd_number.number_to_canonical(l_Calculation_Sum)
2556: ,p_assignment_id => p_assignment_id);
2557:
2558: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2559: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);

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

2558: -- fnd_file.put_line(fnd_file.log,' l_action_info_id '||l_action_info_id);
2559: --fnd_file.put_line(fnd_file.log,' p_archive_assact_id '||p_archive_assact_id);
2560: --fnd_file.put_line(fnd_file.log,' l_actual_termination_date '||l_actual_termination_date);
2561: -- fnd_file.put_line(fnd_file.log,' l_tax_card_type '||l_tax_card_type);
2562: -- fnd_file.put_line(fnd_file.log,' fnd_number.number_to_canonical(l_base_rate) '||fnd_number.number_to_canonical(l_Tax_Percentage));
2563:
2564: -- removed Say Certificate
2565:
2566: -- fnd_file.put_line(fnd_file.log,' Leaving Addl Employee details');

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

3132: ,p_action_information_category => 'EMEA ELEMENT INFO'
3133: ,p_action_information1 => csr_rec.element_type_id
3134: ,p_action_information2 => csr_rec.input_value_id
3135: ,p_action_information3 => 'E'
3136: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3137: ,p_action_information8 => ''
3138: ,p_action_information9 => 'Earning Element:'
3139: ,p_assignment_id => p_assignment_id);
3140:

Line 3145: --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) );

3141: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3142: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3143: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3144: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3145: --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) );
3146: END IF;
3147: END LOOP;
3148:
3149: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

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

3166: ,p_action_information_category => 'EMEA ELEMENT INFO'
3167: ,p_action_information1 => csr_rec.element_type_id
3168: ,p_action_information2 => csr_rec.input_value_id
3169: ,p_action_information3 => 'E'
3170: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3171: ,p_action_information8 => csr_result_rec.record_count
3172: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3173: ,p_assignment_id => p_assignment_id);
3174:

Line 3179: --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) );

3175: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3176: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3177: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3178: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3179: --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) );
3180: END IF;
3181: END LOOP;
3182: END IF;
3183: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

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

3215: ,p_action_information_category => 'EMEA ELEMENT INFO'
3216: ,p_action_information1 => csr_rec.element_type_id
3217: ,p_action_information2 => csr_rec.input_value_id
3218: ,p_action_information3 => 'E'
3219: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3220: ,p_action_information8 => csr_result_rec.UNIT
3221: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3222: ,p_assignment_id => p_assignment_id);
3223:

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

3224: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3225: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3226: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3227: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3228: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3229: END IF;
3230: END LOOP;
3231: ELSE
3232: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

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

3247: ,p_action_information_category => 'EMEA ELEMENT INFO'
3248: ,p_action_information1 => csr_rec.element_type_id
3249: ,p_action_information2 => csr_rec.input_value_id
3250: ,p_action_information3 => 'E'
3251: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3252: ,p_action_information8 => csr_result_rec.UNIT
3253: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3254: ,p_assignment_id => p_assignment_id);
3255:

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

3256: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3257: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3258: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3259: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3260: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3261: END IF; -- end of csr_result_rec.AMOUNT is not null
3262: END LOOP;
3263:
3264: END IF; -- end of rec_group_by.ORG_INFORMATION10 = 'Y'

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

3316: ,p_action_information_category => 'EMEA ELEMENT INFO'
3317: ,p_action_information1 => csr_rec.element_type_id
3318: ,p_action_information2 => csr_rec.input_value_id
3319: ,p_action_information3 => 'E'
3320: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
3321: ,p_action_information8 => l_unit
3322: ,p_action_information9 => 'Earning Element unit per price:'||l_uNIT_PRICE
3323: ,p_assignment_id => p_assignment_id);
3324:

Line 3329: --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) );

3325: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3326: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3327: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3328: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3329: --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) );
3330: END IF; -- end of csr_result_rec.result_value is not null
3331: END LOOP;
3332: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
3333:

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

3352: ,p_action_information_category => 'EMEA ELEMENT INFO'
3353: ,p_action_information1 => csr_rec.element_type_id
3354: ,p_action_information2 => csr_rec.input_value_id
3355: ,p_action_information3 => 'E'
3356: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3357: ,p_action_information8 => csr_result_rec.record_count
3358: ,p_action_information9 => 'Earning Element unit per price:'||csr_result_rec.UNIT_PRICE
3359: ,p_assignment_id => p_assignment_id);
3360:

Line 3365: --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) );

3361: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3362: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3363: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3364: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3365: --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) );
3366: END IF;
3367: END LOOP;
3368: */
3369: --OPEN csr_result_value(csr_rec.input_value_id ,csr_rec.element_type_id ,p_assignment_action_id);

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

3388: ,p_action_information_category => 'EMEA ELEMENT INFO'
3389: ,p_action_information1 => csr_rec.element_type_id
3390: ,p_action_information2 => csr_rec.input_value_id
3391: ,p_action_information3 => 'E'
3392: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3393: --,p_action_information5 => csr_rec.element_code
3394: ,p_action_information9 => 'Earning Element'
3395: ,p_assignment_id => p_assignment_id);
3396:

Line 3401: --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) );

3397: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3398: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3399: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3400: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3401: --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) );
3402: END IF;
3403: END LOOP;
3404: --l_group_by :=NULL;
3405: --ELSE

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

3421: ,p_action_information_category => 'EMEA ELEMENT INFO'
3422: ,p_action_information1 => csr_rec.element_type_id
3423: ,p_action_information2 => csr_rec.input_value_id
3424: ,p_action_information3 => 'E'
3425: ,p_action_information4 => fnd_number.number_to_canonical(l_result_value) --l_formatted_value
3426: --,p_action_information5 => csr_rec.element_code
3427: ,p_action_information9 => 'Earning Element'
3428: ,p_assignment_id => p_assignment_id);
3429:

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

3430: --fnd_file.put_line(fnd_file.log,'GROUP BY YES l_action_info_id ' || l_action_info_id );
3431: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3432: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3433: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3434: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(l_result_value) );
3435: END IF;
3436: l_group_by :=NULL;
3437: END IF; -- end if for the l_group_by*/
3438:

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

3497: ,p_action_information_category => 'EMEA ELEMENT INFO'
3498: ,p_action_information1 => csr_rec.element_type_id
3499: ,p_action_information2 => csr_rec.input_value_id
3500: ,p_action_information3 => 'D'
3501: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3502: ,p_action_information8 => ''
3503: ,p_action_information9 => 'Deduction Element:'
3504: ,p_assignment_id => p_assignment_id);
3505:

Line 3510: --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) );

3506: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3507: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3508: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3509: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3510: --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) );
3511: END IF;
3512: END LOOP;
3513:
3514: ELSIF rec_group_by.ORG_INFORMATION6 = 'Y'

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

3531: ,p_action_information_category => 'EMEA ELEMENT INFO'
3532: ,p_action_information1 => csr_rec.element_type_id
3533: ,p_action_information2 => csr_rec.input_value_id
3534: ,p_action_information3 => 'D'
3535: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3536: ,p_action_information8 => csr_result_rec.record_count
3537: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3538: ,p_assignment_id => p_assignment_id);
3539:

Line 3544: --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) );

3540: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3541: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3542: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3543: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3544: --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) );
3545: END IF;
3546: END LOOP;
3547: END IF;
3548: ELSIF rec_group_by.ORG_INFORMATION3 = 'I'

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

3578: ,p_action_information_category => 'EMEA ELEMENT INFO'
3579: ,p_action_information1 => csr_rec.element_type_id
3580: ,p_action_information2 => csr_rec.input_value_id
3581: ,p_action_information3 => 'D'
3582: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3583: ,p_action_information8 => csr_result_rec.UNIT
3584: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3585: ,p_assignment_id => p_assignment_id);
3586:

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

3587: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3588: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3589: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3590: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3591: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3592: END IF;
3593: END LOOP;
3594: ELSE
3595: FOR csr_result_rec IN csr_all_result_values(rec_group_by.ORG_INFORMATION7

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

3610: ,p_action_information_category => 'EMEA ELEMENT INFO'
3611: ,p_action_information1 => csr_rec.element_type_id
3612: ,p_action_information2 => csr_rec.input_value_id
3613: ,p_action_information3 => 'D'
3614: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.AMOUNT) --l_formatted_value
3615: ,p_action_information8 => csr_result_rec.UNIT
3616: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3617: ,p_assignment_id => p_assignment_id);
3618:

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

3619: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3620: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3621: --fnd_file.put_line(fnd_file.log,'csr_result_rec.UNIT ' || csr_result_rec.UNIT );
3622: --fnd_file.put_line(fnd_file.log,'csr_result_rec.WP WP ' || csr_result_rec.UNIT_PRICE );
3623: --fnd_file.put_line(fnd_file.log,'fnd_number.number_to_canonical(l_result_value) ' || fnd_number.number_to_canonical(csr_result_rec.AMOUNT) );
3624: END IF;
3625: END LOOP;
3626:
3627: END IF;-- end of rec_group_by.ORG_INFORMATION10 = 'Y'

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

3678: ,p_action_information_category => 'EMEA ELEMENT INFO'
3679: ,p_action_information1 => csr_rec.element_type_id
3680: ,p_action_information2 => csr_rec.input_value_id
3681: ,p_action_information3 => 'D'
3682: ,p_action_information4 => fnd_number.number_to_canonical(l_amount) --l_formatted_value
3683: ,p_action_information8 => l_unit
3684: ,p_action_information9 => 'Deduction Element unit per price:'||l_uNIT_PRICE
3685: ,p_assignment_id => p_assignment_id);
3686:

Line 3691: --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) );

3687: --fnd_file.put_line(fnd_file.log,'group by NO l_action_info_id ' || l_action_info_id );
3688: --fnd_file.put_line(fnd_file.log,'Earning Element ');
3689: --fnd_file.put_line(fnd_file.log,'csr_rec.element_type_id ' || csr_rec.element_type_id );
3690: --fnd_file.put_line(fnd_file.log,'csr_rec.input_value_id ' || csr_rec.input_value_id );
3691: --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) );
3692: END IF; -- end of csr_result_rec.result_value is not null
3693: END LOOP;
3694: END IF; -- end of rec_group_by.ORG_INFORMATION9 IS NOT NULL
3695: END IF;

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

3716: ,p_action_information_category => 'EMEA ELEMENT INFO'
3717: ,p_action_information1 => csr_rec.element_type_id
3718: ,p_action_information2 => csr_rec.input_value_id
3719: ,p_action_information3 => 'D'
3720: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3721: ,p_action_information8 => csr_result_rec.record_count
3722: ,p_action_information9 => 'Deduction Element unit per price:'||csr_result_rec.UNIT_PRICE
3723: ,p_assignment_id => p_assignment_id);
3724: END IF;

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

3744: ,p_action_information_category => 'EMEA ELEMENT INFO'
3745: ,p_action_information1 => csr_rec.element_type_id
3746: ,p_action_information2 => csr_rec.input_value_id
3747: ,p_action_information3 => 'D'
3748: ,p_action_information4 => fnd_number.number_to_canonical(csr_result_rec.result_value) --l_formatted_value
3749: --,p_action_information5 => csr_rec.element_code
3750: ,p_action_information9 => 'Deduction Element'
3751: ,p_assignment_id => p_assignment_id);
3752: