1 PACKAGE PAY_SA_GOSI_REPORTS AUTHID CURRENT_USER AS
2 /* $Header: pysagosi.pkh 120.0.12000000.1 2007/01/18 01:14:36 appldev noship $ */
3 --
4 TYPE XMLRec IS RECORD(
5 TagName VARCHAR2(240),
6 TagValue VARCHAR2(240));
7 TYPE tXMLTable IS TABLE OF XMLRec INDEX BY BINARY_INTEGER;
8 vXMLTable tXMLTable;
9 vCtr NUMBER;
10 TYPE r_temp IS RECORD(
11 complaint_id NUMBER(15));
12 TYPE t_temp IS TABLE OF r_temp INDEX BY BINARY_INTEGER;
13 v_temp t_temp;
14 --PROCEDURE run_report
15 -- Procedure to Populate Saudi Workers Movement Data
16 procedure populate_workers_movement
17 ( p_request_id in number,
18 p_report in varchar2,
19 p_business_group_id in number,
20 p_org_structure_version_id in number DEFAULT NULL,
21 p_organisation_id in number,
22 p_form_type in varchar2 DEFAULT NULL,
23 p_effective_date in varchar2,
24 p_assignment_id in number DEFAULT NULL,
25 p_assignment_set_id in number DEFAULT NULL,
26 l_xfdf_blob OUT NOCOPY BLOB);
27 -- Procedure to populate Monthly Contributions
28 procedure populate_monthly_contributions
29 (p_request_id number
30 ,p_report varchar2
31 ,p_business_group_id number
32 ,p_org_structure_version_id number default null
33 ,p_organisation_id number
34 ,p_effective_month varchar2
35 ,p_effective_year varchar2
36 ,p_arrears number default 0
37 ,p_penalty_charge number default 0
38 ,p_discount number default 0
39 ,p_payment_method varchar2 default null
40 ,l_xfdf_blob OUT NOCOPY BLOB);-- Procedure to populate New and Terminated Workers
41 PROCEDURE populate_new_and_term_wrks
42 (p_request_id number
43 ,p_report varchar2
44 ,p_business_group_id number
45 ,p_org_structure_version_id number DEFAULT NULL
46 ,p_organisation_id number
47 ,p_effective_month varchar2
48 ,p_effective_year varchar2
49 ,l_xfdf_blob OUT NOCOPY BLOB);-- Procedure to Write into XML file
50 /*PROCEDURE WritetoXML(
51 p_request_id in number,
52 p_report in varchar2,
53 p_output_fname out nocopy varchar2);*/
54 --Procedure Sum
55 PROCEDURE populate_sum(
56 p_request_id IN NUMBER
57 ,p_from_date IN varchar2
58 ,p_to_date IN varchar2
59 ,p_output_fname OUT NOCOPY VARCHAR2);
60 /*PROCEDURE WriteXMLvalues(p_l_fp utl_file.file_type,p_tagname IN VARCHAR2, p_value IN VARCHAR2);*/
61 PROCEDURE clob_to_blob (p_clob clob,
62 p_blob IN OUT NOCOPY Blob);
63 PROCEDURE WritetoCLOB (p_xfdf_blob out nocopy blob);
64
65
66
67 PROCEDURE fetch_pdf_blob (p_report in varchar2, p_pdf_blob OUT NOCOPY BLOB);
68 END PAY_SA_GOSI_REPORTS;