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.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_DI_INSERT

Line 581: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

577: --The next step is to see if there are any referencing columns
578: --associated with the api (in R_REF_COL_APIS)
579: l_new_string := null;
580:
581: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
582: g_insert_table(i).r_ref_Col_apis);
583:
584: l_number_references :=
585: hr_du_di_insert.WORDS_ON_LINE(g_insert_table(i).r_ref_Col_apis);

Line 585: hr_du_di_insert.WORDS_ON_LINE(g_insert_table(i).r_ref_Col_apis);

581: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
582: g_insert_table(i).r_ref_Col_apis);
583:
584: l_number_references :=
585: hr_du_di_insert.WORDS_ON_LINE(g_insert_table(i).r_ref_Col_apis);
586:
587: hr_du_utility.message('INFO', g_insert_table(i).r_ref_Col_apis , 10);
588:
589: --loop around for each reference trying to match its api id with the

Line 594: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

590: --table id
591: FOR j IN 1..l_number_references LOOP
592: l_reference_pval := null;
593:
594: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
595: g_insert_table(i).r_ref_Col_apis);
596:
597: l_reference_pval := hr_du_di_insert.Return_Word(
598: g_insert_table(i).r_ref_Col_apis, j);

Line 597: l_reference_pval := hr_du_di_insert.Return_Word(

593:
594: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
595: g_insert_table(i).r_ref_Col_apis);
596:
597: l_reference_pval := hr_du_di_insert.Return_Word(
598: g_insert_table(i).r_ref_Col_apis, j);
599:
600: hr_du_utility.message('INFO', l_reference_pval , 15);
601:

Line 1023: hr_du_di_insert.g_current_delimiter := ',';

1019: hr_du_utility.message('PARA', '(p_upload_id - ' || p_upload_id || ')' , 10);
1020: --
1021:
1022: --sets the delimiter through out the whole package to be a comma
1023: hr_du_di_insert.g_current_delimiter := ',';
1024:
1025: OPEN csr_apis;
1026: LOOP
1027: --

Line 1692: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters

1688:
1689: --Next step is to see if there are any referencing columns
1690: --associated with the api_module
1691:
1692: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters
1693: (g_insert_table(p_target_api_module).r_ref_Col_apis);
1694:
1695: l_number_references :=
1696: hr_du_di_insert.WORDS_ON_LINE(g_insert_table

Line 1696: hr_du_di_insert.WORDS_ON_LINE(g_insert_table

1692: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters
1693: (g_insert_table(p_target_api_module).r_ref_Col_apis);
1694:
1695: l_number_references :=
1696: hr_du_di_insert.WORDS_ON_LINE(g_insert_table
1697: (p_target_api_module).r_ref_Col_apis);
1698:
1699: --if l_number_references is zero then it won't enter the loop
1700: FOR i IN 1..l_number_references LOOP

Line 1704: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1700: FOR i IN 1..l_number_references LOOP
1701: --
1702: --Find the appropriate column in the old PC row where the referencing
1703: --details are held
1704: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1705: g_insert_table(p_target_api_module).r_ref_PVAL);
1706:
1707: l_reference_pval := hr_du_di_insert.Return_Word(
1708: g_insert_table(p_target_api_module).r_ref_PVAL, i);

Line 1707: l_reference_pval := hr_du_di_insert.Return_Word(

1703: --details are held
1704: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1705: g_insert_table(p_target_api_module).r_ref_PVAL);
1706:
1707: l_reference_pval := hr_du_di_insert.Return_Word(
1708: g_insert_table(p_target_api_module).r_ref_PVAL, i);
1709:
1710: hr_du_utility.message('INFO', 'l_reference_pval : '
1711: || l_reference_pval, 25);

Line 1715: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1711: || l_reference_pval, 25);
1712:
1713: --identify the target row in the PL/SQL table that holds all of the
1714: --information on that particular api_module
1715: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1716: g_insert_table(p_target_api_module).r_ref_Col_apis);
1717:
1718: l_target_api_module := hr_du_di_insert.Return_Word(
1719: g_insert_table(p_target_api_module).r_ref_Col_apis, i);

Line 1718: l_target_api_module := hr_du_di_insert.Return_Word(

1714: --information on that particular api_module
1715: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1716: g_insert_table(p_target_api_module).r_ref_Col_apis);
1717:
1718: l_target_api_module := hr_du_di_insert.Return_Word(
1719: g_insert_table(p_target_api_module).r_ref_Col_apis, i);
1720:
1721: hr_du_utility.message('INFO', 'l_target_api_module : '
1722: || l_target_api_module, 30);

Line 1781: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1777: --check to see whether I have to add information to the current line
1778: --to hold details about the calling line
1779: IF p_prev_upload_line_id IS NOT NULL THEN
1780:
1781: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1782: g_insert_table(p_target_api_module).r_string_apis);
1783: l_number_references := hr_du_di_insert.WORDS_ON_LINE(
1784: g_insert_table(p_target_api_module).r_string_apis);
1785:

Line 1783: l_number_references := hr_du_di_insert.WORDS_ON_LINE(

1779: IF p_prev_upload_line_id IS NOT NULL THEN
1780:
1781: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1782: g_insert_table(p_target_api_module).r_string_apis);
1783: l_number_references := hr_du_di_insert.WORDS_ON_LINE(
1784: g_insert_table(p_target_api_module).r_string_apis);
1785:
1786: hr_du_utility.message('INFO', 'r_string_apis : ' ||
1787: g_insert_table(p_target_api_module).r_string_apis ,50);

Line 1794: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1790: --this loop catches all occurrences
1791: FOR j IN 1..l_number_references LOOP
1792: --
1793: --Extracts the first api_module id from R_STRING_APIS
1794: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1795: g_insert_table(p_target_api_module).r_string_apis);
1796: l_single_api_module := hr_du_di_insert.Return_Word(
1797: g_insert_table(p_target_api_module).r_string_apis, j);
1798:

Line 1796: l_single_api_module := hr_du_di_insert.Return_Word(

1792: --
1793: --Extracts the first api_module id from R_STRING_APIS
1794: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1795: g_insert_table(p_target_api_module).r_string_apis);
1796: l_single_api_module := hr_du_di_insert.Return_Word(
1797: g_insert_table(p_target_api_module).r_string_apis, j);
1798:
1799: --checks for a match with api_module id's in R_STRING_APIS
1800: --and the old api_module id from the calling line (p_prev_table_number)

Line 1806: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1802: g_insert_table(p_prev_table_number).r_api_id THEN
1803: --
1804: --Recalls the pval*** in the PL/SQL table so the data can be stored
1805: --in the correct position in the UPLOAD_LINE
1806: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1807: g_insert_table(p_target_api_module).R_API_PVALS);
1808: l_single_pval := hr_du_di_insert.Return_Word(
1809: g_insert_table(p_target_api_module).R_API_PVALS, j);
1810:

Line 1808: l_single_pval := hr_du_di_insert.Return_Word(

1804: --Recalls the pval*** in the PL/SQL table so the data can be stored
1805: --in the correct position in the UPLOAD_LINE
1806: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1807: g_insert_table(p_target_api_module).R_API_PVALS);
1808: l_single_pval := hr_du_di_insert.Return_Word(
1809: g_insert_table(p_target_api_module).R_API_PVALS, j);
1810:
1811: --modifies the line with the extra CP referencing information
1812: l_built_up_string1 := 'update HR_DU_UPLOAD_LINES SET ' ||

Line 1833: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1829: --first one it comes across
1830: IF l_found_flag = FALSE THEN
1831: FOR j IN 1..l_number_references LOOP
1832: --
1833: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1834: g_insert_table(p_target_api_module).r_string_apis);
1835: l_single_api_module := hr_du_di_insert.Return_Word(
1836: g_insert_table(p_target_api_module).r_string_apis, j);
1837:

Line 1835: l_single_api_module := hr_du_di_insert.Return_Word(

1831: FOR j IN 1..l_number_references LOOP
1832: --
1833: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1834: g_insert_table(p_target_api_module).r_string_apis);
1835: l_single_api_module := hr_du_di_insert.Return_Word(
1836: g_insert_table(p_target_api_module).r_string_apis, j);
1837:
1838: IF l_single_api_module IS NULL THEN
1839: --

Line 1840: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1836: g_insert_table(p_target_api_module).r_string_apis, j);
1837:
1838: IF l_single_api_module IS NULL THEN
1839: --
1840: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1841: g_insert_table(p_target_api_module).R_API_PVALS);
1842: l_single_pval := hr_du_di_insert.Return_Word(
1843: g_insert_table(p_target_api_module).R_API_PVALS, j);
1844:

Line 1842: l_single_pval := hr_du_di_insert.Return_Word(

1838: IF l_single_api_module IS NULL THEN
1839: --
1840: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1841: g_insert_table(p_target_api_module).R_API_PVALS);
1842: l_single_pval := hr_du_di_insert.Return_Word(
1843: g_insert_table(p_target_api_module).R_API_PVALS, j);
1844:
1845: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1846: g_insert_table(p_target_api_module).r_generic_pval);

Line 1845: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(

1841: g_insert_table(p_target_api_module).R_API_PVALS);
1842: l_single_pval := hr_du_di_insert.Return_Word(
1843: g_insert_table(p_target_api_module).R_API_PVALS, j);
1844:
1845: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1846: g_insert_table(p_target_api_module).r_generic_pval);
1847: l_generic_pval := hr_du_di_insert.Return_Word(
1848: g_insert_table(p_target_api_module).r_generic_pval, j);
1849:

Line 1847: l_generic_pval := hr_du_di_insert.Return_Word(

1843: g_insert_table(p_target_api_module).R_API_PVALS, j);
1844:
1845: hr_du_di_insert.g_delimiter_count := hr_du_di_insert.Num_Delimiters(
1846: g_insert_table(p_target_api_module).r_generic_pval);
1847: l_generic_pval := hr_du_di_insert.Return_Word(
1848: g_insert_table(p_target_api_module).r_generic_pval, j);
1849:
1850: l_built_up_string3 := 'update HR_DU_UPLOAD_LINES SET ' ||
1851: l_single_pval || ' = ''' || p_prev_upload_line_id