[Home] [Help]
2078: SET status = 'S'
2079: WHERE upload_line_id = l_upload_line_id;
2080:
2081: --If statements inserted here to call the appropriate procedure within
2082: --HR_DU_DO_ENTITIES so that the insert statements are build up correctly
2083:
2084: hr_du_utility.message('INFO',upper(l_api_name), 20);
2085:
2086: IF upper(l_api_name) = 'CREATE_US_EMPLOYEE' OR
2084: hr_du_utility.message('INFO',upper(l_api_name), 20);
2085:
2086: IF upper(l_api_name) = 'CREATE_US_EMPLOYEE' OR
2087: upper(l_api_name) = 'CREATE_GB_EMPLOYEE' THEN
2088: hr_du_do_entities.CREATE_DEFAULT_EMPLOYEE(g_values_table(i), p_upload_id,
2089: l_batch_id, l_api_module_id, l_process_order,
2090: l_upload_line_id, l_api_name_thirty, l_pump_batch_line_id);
2091: ELSIF upper(l_api_name) = 'UPDATE_EMP_ASG_CRITERIA' THEN
2092: hr_du_do_entities.UPDATE_EMP_ASG_CRITERIA(g_values_table(i),
2088: hr_du_do_entities.CREATE_DEFAULT_EMPLOYEE(g_values_table(i), p_upload_id,
2089: l_batch_id, l_api_module_id, l_process_order,
2090: l_upload_line_id, l_api_name_thirty, l_pump_batch_line_id);
2091: ELSIF upper(l_api_name) = 'UPDATE_EMP_ASG_CRITERIA' THEN
2092: hr_du_do_entities.UPDATE_EMP_ASG_CRITERIA(g_values_table(i),
2093: p_upload_id, l_batch_id, l_api_module_id,
2094: l_process_order, l_upload_line_id, l_api_name_thirty,
2095: l_pump_batch_line_id);
2096: ELSIF g_values_table(i).r_user_key_pval IS NULL THEN
2093: p_upload_id, l_batch_id, l_api_module_id,
2094: l_process_order, l_upload_line_id, l_api_name_thirty,
2095: l_pump_batch_line_id);
2096: ELSIF g_values_table(i).r_user_key_pval IS NULL THEN
2097: hr_du_do_entities.DEFAULT_API_NULL(g_values_table(i), p_upload_id,
2098: l_batch_id, l_api_module_id, l_process_order,
2099: l_upload_line_id, l_api_name_thirty,l_pump_batch_line_id);
2100: ELSE
2101: hr_du_do_entities.DEFAULT_API(g_values_table(i), p_upload_id,
2097: hr_du_do_entities.DEFAULT_API_NULL(g_values_table(i), p_upload_id,
2098: l_batch_id, l_api_module_id, l_process_order,
2099: l_upload_line_id, l_api_name_thirty,l_pump_batch_line_id);
2100: ELSE
2101: hr_du_do_entities.DEFAULT_API(g_values_table(i), p_upload_id,
2102: l_batch_id, l_api_module_id, l_process_order,
2103: l_upload_line_id, l_api_name_thirty,l_pump_batch_line_id);
2104: END IF;
2105: