PACKAGE: APPS.PER_FR_BIAF_REPORT

Source

1 PACKAGE PER_FR_BIAF_REPORT AUTHID CURRENT_USER as
2 /* $Header: pefrbiaf.pkh 120.5 2006/02/19 21:58 sbairagi noship $ */
3 TYPE XMLRec IS RECORD(
4 TagName VARCHAR2(1000),
5 TagValue VARCHAR2(1000));
6 
7 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
8 vXMLTable tXMLTable;
9 
10 PROCEDURE fill_table (p_employee_number IN varchar2,p_bg_id IN NUMBER ,p_asg_id NUMBER,p_effective_date date);
11 FUNCTION  get_contract_start_date(f_person_id IN number) return date;
12 FUNCTION  get_contract_end_date(f_person_id IN number) return date;
13 FUNCTION get_emp_total (lp_effective_date    IN DATE,
14                         lp_est_id            IN NUMBER ,
15                        -- lp_ent_id            IN NUMBER ,
16                        -- lp_sex               IN VARCHAR2,
17                         lp_udt_column        IN VARCHAR2
18                         --lp_include_suspended IN VARCHAR2
19 			) RETURN NUMBER ;
20 
21 PROCEDURE POPULATE_REPORT_DATA(p_employee_number IN varchar2,p_bg_id IN NUMBER ,p_asg_id NUMBER,p_asg_emp varchar2 ,p_effective_date varchar2 ,p_xfdf_blob OUT NOCOPY BLOB);
22 PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob);
23 PROCEDURE clob_to_blob (p_clob clob,
24                         p_blob IN OUT NOCOPY Blob);
25 
26 
27 
28 END PER_FR_BIAF_REPORT;