[Home] [Help]
1210: --*************************************
1211: -- This function returns the full_name of the person. If there are multiple
1212: -- records it will get the name which is valid on the effective/distribution date. If person_id
1213: -- or effective/distribution date is invalid, it will return an error message.
1214: -- This function is called from psp_payroll_interface_v and psp_distribution_interface_v
1215:
1216: FUNCTION get_person_name
1217: (p_person_id IN NUMBER,
1218: p_effective_date IN DATE)
1246: ---- FUNCTION get_assignment_num
1247: --*************************************
1248: -- This function returns assignment number for the given assignment_id and effective_date/distribution_date.
1249: -- If no row exists for the given parameter, it will return an error message.
1250: -- This function is called from psp_payroll_interface_v and psp_distribution_interface_v
1251:
1252: FUNCTION get_assignment_num
1253: (p_assignment_id IN NUMBER,
1254: p_effective_date IN DATE)
1284: ---- FUNCTION get_payroll_name
1285: --*************************************
1286: -- This function returns the payroll name for the given payroll_id and effective_date/distribution_date.
1287: -- If no row exists for the given parameters, an error message is returned.
1288: -- This function is called from psp_payroll_interface_v and psp_distribution_interface_v
1289:
1290:
1291: FUNCTION get_payroll_name
1292: (p_payroll_id IN NUMBER,
3599: AND ROWNUM = 1;
3600:
3601: CURSOR c_distribution_interface IS
3602: SELECT 1
3603: FROM psp_distribution_interface
3604: WHERE project_id = nvl (p_project_id, project_id)
3605: AND task_id = nvl (p_task_id, task_id)
3606: AND project_id is NOT NULL
3607: AND ROWNUM = 1;
3923: IF l_return_flag <> 0 THEN
3924: RETURN l_return_flag;
3925: END IF;
3926:
3927: -- Validation of project_id and task_id in pre gen dist lines and psp_distribution_interface table
3928:
3929: l_return_flag := chk_in_psp_pre_gen_dist_lines;
3930: IF l_return_flag <> 0 THEN
3931: RETURN l_return_flag;