APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PER_ALL_PEOPLE_F

Line 5: TYPE hol_card_emp IS RECORD ( emp_name per_all_people_f.full_name%type,

1: PACKAGE BODY PAY_DK_EHOL_CARD_REQUEST AS
2: /* $Header: pydkeholreq.pkb 120.0.12020000.2 2012/07/18 06:52:00 rsahai noship $ */
3:
4:
5: TYPE hol_card_emp IS RECORD ( emp_name per_all_people_f.full_name%type,
6: assignmnet_number per_all_assignments_f.assignment_number%type,
7: cpr_number per_all_people_f.national_identifier%type,
8: hire_date varchar2(50) ,
9: start_date varchar2(15),

Line 7: cpr_number per_all_people_f.national_identifier%type,

3:
4:
5: TYPE hol_card_emp IS RECORD ( emp_name per_all_people_f.full_name%type,
6: assignmnet_number per_all_assignments_f.assignment_number%type,
7: cpr_number per_all_people_f.national_identifier%type,
8: hire_date varchar2(50) ,
9: start_date varchar2(15),
10: no_of_hol varchar2(5) ,
11: year varchar2(10) );

Line 33: TYPE error_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,

29: g_legal_employer_id hr_organization_information.organization_id%type;
30: g_effective_date date;
31: g_vendor_id varchar2(25);
32:
33: TYPE error_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
34: -- p_cpr_number per_all_people_f.national_identifier%type,
35: p_assg_number per_all_assignments_f.assignment_number%type,
36: p_err_msg VARCHAR2(1000),
37: p_absence_start date,

Line 34: -- p_cpr_number per_all_people_f.national_identifier%type,

30: g_effective_date date;
31: g_vendor_id varchar2(25);
32:
33: TYPE error_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
34: -- p_cpr_number per_all_people_f.national_identifier%type,
35: p_assg_number per_all_assignments_f.assignment_number%type,
36: p_err_msg VARCHAR2(1000),
37: p_absence_start date,
38: p_duration number);

Line 45: TYPE process_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,

41:
42: l_err_tab err_tab;
43: err_cnt number := 1;
44:
45: TYPE process_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
46: -- p_cpr_number per_all_people_f.national_identifier%type,
47: p_assg_number per_all_assignments_f.assignment_number%type,
48: p_proc_msg VARCHAR2(1000),
49: p_absence_start date,

Line 46: -- p_cpr_number per_all_people_f.national_identifier%type,

42: l_err_tab err_tab;
43: err_cnt number := 1;
44:
45: TYPE process_rec IS RECORD ( -- emp_name per_all_people_f.full_name%type ,
46: -- p_cpr_number per_all_people_f.national_identifier%type,
47: p_assg_number per_all_assignments_f.assignment_number%type,
48: p_proc_msg VARCHAR2(1000),
49: p_absence_start date,
50: p_duration number);

Line 131: ,per_all_people_f per

127: , eev1.screen_entry_value screen_entry_value
128: , iv1.name
129: FROM per_all_assignments_f asg1
130: ,per_all_assignments_f asg2
131: ,per_all_people_f per
132: ,pay_element_links_f el
133: ,pay_element_types_f et
134: ,pay_input_values_f iv1
135: ,pay_element_entries_f ee

Line 578: l_person_id per_all_people_f.person_id%type;

574:
575: l_start_date date;
576: l_end_date date;
577: l_effective_date DATE;
578: l_person_id per_all_people_f.person_id%type;
579: l_business_group_id hr_organization_units.business_group_id%type;
580: l_abs_attendance_id per_absence_attendance_types.absence_attendance_type_id%type;
581: --l_assignment_id number;
582:

Line 732: l_name per_all_people_f.full_name%type;

728: l_end_date date;
729: l_holidays varchar2(20);
730: l_assg_id per_all_assignments_f.assignment_id%type;
731: l_year varchar2(10);
732: l_name per_all_people_f.full_name%type;
733: l_return NUMBER;
734: l_param VARCHAR2(100);
735: e_record_too_long EXCEPTION;
736: name_is_null EXCEPTION;

Line 778: FROM per_all_people_f per ,

774: AND eev1.screen_entry_value = p_run_id;
775:
776: CURSOR chk_multiple_assg(p_assig_no varchar2, p_cpr_no varchar2) IS
777: SELECT asg2.ASSIGNMENT_ID
778: FROM per_all_people_f per ,
779: per_all_assignments_f asg1,
780: per_all_assignments_f asg2
781: WHERE asg1.assignment_number = p_assig_no
782: AND per.NATIONAL_IDENTIFIER = p_cpr_no