[Home] [Help]
419: In this mechanism we have used 2 functions GET_ASG_PAY_END_DATE and
420: get_payroll_pay_end_date. GET_ASG_PAY_END_DATE is used for both ORACLE
421: and NON ORACLE PAYROLL in order to increase the performance of the CUEL
422: process and this is used in the insert statement of PSP_ENC_CHANGED_ASSIGNMENTS.
423: For this we have created a temp table PSP_ASG_END_DATES in order
424: to hold assignment information until the CUEL process completes.
425:
426: Before this process was introduced the cursor query of
427: ORACLE_PAYROLL_ASG_END_DATE (ORACLE PAYROLL CURSOR) is used in all the
496: AND ptp.payroll_id = ppa.payroll_id;
497:
498: cursor asgn_end_date_cur is
499: select assignment_id,asg_end_date
500: from psp_asg_end_dates
501: where assignment_id = p_assignmnet_id
502: and payroll_id = p_payroll_id
503: and bg_grp_id = p_business_group_id
504: and payroll_action_id = p_payroll_action_id;
535: END IF;
536:
537:
538:
539: insert into psp_asg_end_dates (PAYROLL_ACTION_ID ,ASSIGNMENT_ID ,PAYROLL_ID ,BG_GRP_ID ,ASG_END_DATE ) --jnerella 26/07/2012
540: values(p_payroll_action_id,p_assignmnet_id,p_payroll_id,p_business_group_id,l_asgn_end_date);
541: -- fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' fnd:::If table --- > insert '||sql%rowcount);
542: -- hr_utility.trace(' hr:::If table --- > insert '||sql%rowcount);
543:
7960:
7961: -- 13566809 The delete statement deletes all the assignment information
7962: -- from temp table before the CUEL process completes.
7963:
7964: DELETE FROM psp_asg_end_dates
7965: WHERE payroll_action_id = p_payroll_action_id;
7966:
7967: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleting data from the temporary dummy table'||sql%rowcount);
7968: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE)|| ' Deleting data from the temporary dummy table'||sql%rowcount);