APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_UPLOAD_LINES_S

Line 1642: Select HR_DU_UPLOAD_LINES_S.nextval

1638: UPDATE hr_du_upload_lines
1639: SET status = 'S'
1640: WHERE upload_line_id = l_upload_line_id;
1641:
1642: Select HR_DU_UPLOAD_LINES_S.nextval
1643: INTO l_line_id
1644: FROM dual;
1645:
1646: Select ORIGINAL_UPLOAD_HEADER_ID

Line 1812: l_built_up_string1 := 'update HR_DU_UPLOAD_LINES SET ' ||

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 ' ||
1813: l_single_pval || ' = ''' || p_prev_upload_line_id ||
1814: ''' WHERE upload_line_id = ' || l_line_id;
1815:
1816: hr_du_utility.message('INFO', l_built_up_string1 ,50);

Line 1850: l_built_up_string3 := 'update HR_DU_UPLOAD_LINES SET ' ||

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
1852: || ''',' || l_generic_pval || ' = ''' ||
1853: g_insert_table(p_prev_table_number).r_api_id ||
1854: ''' WHERE upload_line_id = ' || l_line_id;