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 528: Removing the records from per_ca_ee_report_lines table

524: /* Added by ssmukher for Bug */
525: l_asgchk_flag := 'Y';
526:
527: /* Added by ssmukher in v115.1
528: Removing the records from per_ca_ee_report_lines table
529: before running any new report */
530: delete
531: from per_ca_ee_report_lines
532: where request_id in (10,20,30);

Line 531: from per_ca_ee_report_lines

527: /* Added by ssmukher in v115.1
528: Removing the records from per_ca_ee_report_lines table
529: before running any new report */
530: delete
531: from per_ca_ee_report_lines
532: where request_id in (10,20,30);
533:
534: /* Caching data from per_jobs and per_person_types tables */
535:

Line 740: per_ca_ee_report_lines (REQUEST_ID ,

736:
737: if l_flag = 'N' or l_flag_sal = 'Y' then
738: l_excep_cnt := l_excep_cnt + 1;
739: insert into
740: per_ca_ee_report_lines (REQUEST_ID ,
741: LINE_NUMBER,
742: CONTEXT,
743: SEGMENT1,
744: SEGMENT2,

Line 811: per_ca_ee_report_lines (REQUEST_ID ,

807: l_end_dt := trunc(to_date(to_char(v_year_end,'YYYY')+101,'YYYY'),'YYYY')-1;
808: hr_utility.trace('l_end_dt '||to_char(l_end_dt,'YYYY-MM-DD'));
809: end if;
810: insert into
811: per_ca_ee_report_lines (REQUEST_ID ,
812: LINE_NUMBER,
813: CONTEXT,
814: SEGMENT1,
815: SEGMENT2,

Line 899: per_ca_ee_report_lines (REQUEST_ID ,

895: end if;
896: l_promo_cnt := l_promo_cnt + 1;
897:
898: insert into
899: per_ca_ee_report_lines (REQUEST_ID ,
900: LINE_NUMBER,
901: CONTEXT,
902: SEGMENT1,
903: SEGMENT2)

Line 934: per_ca_ee_report_lines (REQUEST_ID ,

930: hr_utility.trace('Inside the PLSQl table ');
931: hr_utility.trace('The value of the date fetched is '||table_date(i));
932: l_promo_cnt := l_promo_cnt + 1;
933: insert into
934: per_ca_ee_report_lines (REQUEST_ID ,
935: LINE_NUMBER,
936: CONTEXT,
937: SEGMENT1,
938: SEGMENT2)

Line 972: from per_ca_ee_report_lines pcer

968: cursor c_promo_details is
969: select segment1 emp_no,
970: --to_number(segment1) emp_no, bug 10287946
971: segment2 promo_dt
972: from per_ca_ee_report_lines pcer
973: where pcer.context = 'PROMO' and
974: pcer.request_id = 20
975: order by emp_no,promo_dt;
976:

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

997: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;
998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
999: l_prev_emp := l_emp_no;
1000: end loop;
1001: /* Deleteing the promotion records from per_ca_ee_report_lines table */
1002: delete from
1003: per_ca_ee_report_lines
1004: where request_id = 20 and context = 'PROMO';
1005: commit;

Line 1003: per_ca_ee_report_lines

999: l_prev_emp := l_emp_no;
1000: end loop;
1001: /* Deleteing the promotion records from per_ca_ee_report_lines table */
1002: delete from
1003: per_ca_ee_report_lines
1004: where request_id = 20 and context = 'PROMO';
1005: commit;
1006: end ;
1007: /*************** End of Procedure to print the Promotion details list *****/

Line 1022: from per_ca_ee_report_lines pcer

1018: --to_number(segment1) emp_no, bug 10287946
1019: segment2 start_dt,
1020: segment3 end_dt,
1021: segment4 term_dt
1022: from per_ca_ee_report_lines pcer
1023: where pcer.context = 'TMP' and
1024: pcer.request_id = 10
1025: order by emp_no;
1026:

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

1070: end if;*/
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
1072: l_prev_emp := l_emp_no;
1073: end loop;
1074: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */
1075: delete from
1076: per_ca_ee_report_lines
1077: where request_id = 10 and context ='TMP';
1078: commit;

Line 1076: per_ca_ee_report_lines

1072: l_prev_emp := l_emp_no;
1073: end loop;
1074: /* Deleting the temporary employee records from the per_ca_ee_report_lines table */
1075: delete from
1076: per_ca_ee_report_lines
1077: where request_id = 10 and context ='TMP';
1078: commit;
1079: END ;
1080:

Line 1101: from per_ca_ee_report_lines pcer

1097: segment4 cma,
1098: segment5 emp_catg,
1099: segment6 sal,
1100: segment7 noc
1101: from per_ca_ee_report_lines pcer
1102: where pcer.request_id = 30 and
1103: pcer.context = 'EXCEP'
1104: order by emp_no;
1105: l_emp_no per_all_people_f.employee_number%type;

Line 1177: per_ca_ee_report_lines

1173: end loop;
1174: close c_excep_report;
1175: /* Delete the Exception employee records from the Temporary tables */
1176: delete from
1177: per_ca_ee_report_lines
1178: where request_id = 30 and
1179: context = 'EXCEP';
1180: commit;
1181: end;