APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_CA_EE_REPORT_LINES

Line 35: remove records from per_ca_ee_report_lines

31: 04-Jul-2005 ssmukher 115.1 Removed the cursor cur_term_asg
32: Modified the CMA code values in the
33: cursor cur_emp_cma, added another delete
34: stmt at the start of the procedure to
35: remove records from per_ca_ee_report_lines
36: table,added an additional check before
37: inserting temporary employees as well as
38: Promoted employee details.
39: 05-Jul-2005 ssmukher 115.2 Modified the cursor c_promo.

Line 467: Removing the records from per_ca_ee_report_lines table

463: /* Added by ssmukher for Bug */
464: l_asgchk_flag := 'Y';
465:
466: /* Added by ssmukher in v115.1
467: Removing the records from per_ca_ee_report_lines table
468: before running any new report */
469: delete
470: from per_ca_ee_report_lines
471: where request_id in (10,20,30);

Line 470: from per_ca_ee_report_lines

466: /* Added by ssmukher in v115.1
467: Removing the records from per_ca_ee_report_lines table
468: before running any new report */
469: delete
470: from per_ca_ee_report_lines
471: where request_id in (10,20,30);
472:
473: /* Caching data from per_jobs and per_person_types tables */
474:

Line 676: per_ca_ee_report_lines (REQUEST_ID ,

672:
673: if l_flag = 'N' then
674: l_excep_cnt := l_excep_cnt + 1;
675: insert into
676: per_ca_ee_report_lines (REQUEST_ID ,
677: LINE_NUMBER,
678: CONTEXT,
679: SEGMENT1,
680: SEGMENT2,

Line 739: per_ca_ee_report_lines (REQUEST_ID ,

735: if l_cnt_flag = 'Y' then
736: l_tmp_cnt := l_tmp_cnt + 1;
737: end if;
738: insert into
739: per_ca_ee_report_lines (REQUEST_ID ,
740: LINE_NUMBER,
741: CONTEXT,
742: SEGMENT1,
743: SEGMENT2,

Line 818: per_ca_ee_report_lines (REQUEST_ID ,

814: end if;
815: l_promo_cnt := l_promo_cnt + 1;
816:
817: insert into
818: per_ca_ee_report_lines (REQUEST_ID ,
819: LINE_NUMBER,
820: CONTEXT,
821: SEGMENT1,
822: SEGMENT2)

Line 854: per_ca_ee_report_lines (REQUEST_ID ,

850: hr_utility.trace('Inside the PLSQl table ');
851: hr_utility.trace('The value of the date fetched is '||table_date(i));
852: l_promo_cnt := l_promo_cnt + 1;
853: insert into
854: per_ca_ee_report_lines (REQUEST_ID ,
855: LINE_NUMBER,
856: CONTEXT,
857: SEGMENT1,
858: SEGMENT2)

Line 893: from per_ca_ee_report_lines pcer

889:
890: cursor c_promo_details is
891: select to_number(segment1) emp_no,
892: segment2 promo_dt
893: from per_ca_ee_report_lines pcer
894: where pcer.context = 'PROMO' and
895: pcer.request_id = 20
896: order by emp_no,promo_dt;
897:

Line 922: /* Deleteing the promotion records from per_ca_ee_report_lines table */

918: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;
919: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
920: l_prev_emp := l_emp_no;
921: end loop;
922: /* Deleteing the promotion records from per_ca_ee_report_lines table */
923: delete from
924: per_ca_ee_report_lines
925: where request_id = 20 and context = 'PROMO';
926: commit;

Line 924: per_ca_ee_report_lines

920: l_prev_emp := l_emp_no;
921: end loop;
922: /* Deleteing the promotion records from per_ca_ee_report_lines table */
923: delete from
924: per_ca_ee_report_lines
925: where request_id = 20 and context = 'PROMO';
926: commit;
927: end ;
928: /*************** End of Procedure to print the Promotion details list *****/

Line 942: from per_ca_ee_report_lines pcer

938: select to_number(segment1) emp_no,
939: segment2 start_dt,
940: segment3 end_dt,
941: segment4 term_dt
942: from per_ca_ee_report_lines pcer
943: where pcer.context = 'TMP' and
944: pcer.request_id = 10
945: order by emp_no;
946:

Line 992: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */

988: end if;
989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
990: l_prev_emp := l_emp_no;
991: end loop;
992: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */
993: delete from
994: per_ca_ee_report_lines
995: where request_id = 10 and context ='TMP';
996: commit;

Line 994: per_ca_ee_report_lines

990: l_prev_emp := l_emp_no;
991: end loop;
992: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */
993: delete from
994: per_ca_ee_report_lines
995: where request_id = 10 and context ='TMP';
996: commit;
997: END ;
998:

Line 1017: from per_ca_ee_report_lines pcer

1013: segment3 naic,
1014: segment4 cma,
1015: segment5 emp_catg,
1016: segment6 sal
1017: from per_ca_ee_report_lines pcer
1018: where pcer.request_id = 30 and
1019: pcer.context = 'EXCEP'
1020: order by emp_no;
1021: l_emp_no per_all_people_f.employee_number%type;

Line 1083: per_ca_ee_report_lines

1079: end loop;
1080: close c_excep_report;
1081: /* Delete the Exception employee records from the Temporary tables */
1082: delete from
1083: per_ca_ee_report_lines
1084: where request_id = 30 and
1085: context = 'EXCEP';
1086: commit;
1087: end;