[Home] [Help]
PACKAGE: APPS.GHR_GEN_RPA_NPA
Source
1 PACKAGE GHR_GEN_RPA_NPA AS
2 /* $Header: ghgenpa.pkh 120.0.12010000.1 2008/07/28 10:31:14 appldev ship $ */
3 -- ============================================================================
4 -- << Procedure: execute_mt >>
5 -- Description:
6 -- This procedure is called from concurrent program. This procedure will
7 -- determine the batch size and call sub programs.
8 -- ============================================================================
9 TYPE t_rpa_misc_fields IS RECORD
10 (
11 action_requested GHR_FAMILIES.NAME%TYPE,
12 additional_info_name VARCHAR2(200),
13 requested_by VARCHAR2(200),
14 authorized_by VARCHAR2(200),
15 employee_name VARCHAR2(200),
16 appropriation_code varchar2(100),
17 from_position_org_lines VARCHAR2(1000),
18 to_position_org_lines VARCHAR2(1000),
19 agency_code_use VARCHAR2(250),
20 agency_data40 VARCHAR2(250),
21 agency_data41 VARCHAR2(250),
22 agency_data42 VARCHAR2(250),
23 agency_data43 VARCHAR2(250),
24 agency_data44 VARCHAR2(250),
25 veterance_preference_for_rif_y VARCHAR2(1),
26 veterance_preference_for_rif_n VARCHAR2(1),
27 requesting_office_rem_flag_y VARCHAR2(1),
28 requesting_office_rem_flag_n VARCHAR2(1),
29 forwarding_city VARCHAR2(1000),
30 remarks_concat VARCHAR2(1000),
31 from_tot_sal_or_awd VARCHAR2(50),
32 to_tot_sal_or_awd VARCHAR2(50)
33 );
34
35 TYPE t_remarks IS RECORD
36 (
37 remarks_desc ghr_pa_remarks.description%type,
38 remark_code ghr_remarks.code%type);
39
40 -- Type for RPA/NPA Tags
41 TYPE t_report_tags IS RECORD
42 (
43 tag_name VARCHAR2(50),
44 par_field_value VARCHAR2(1000));
45
46 TYPE t_signatures IS RECORD
47 (
48 office_function varchar2(100),
49 office_signature varchar2(100),
50 office_date varchar2(100));
51
52 /**************************************For Populating RPA **************************************/
53 TYPE t_rpa_misc_fields_rec IS TABLE OF t_rpa_misc_fields INDEX BY BINARY_INTEGER;
54 TYPE t_report_tags_rec IS TABLE OF t_report_tags INDEX BY BINARY_INTEGER;
55 TYPE t_signature_rec IS TABLE OF t_signatures INDEX BY BINARY_INTEGER;
56 TYPE t_remarks_rec IS TABLE OF t_remarks INDEX BY BINARY_INTEGER;
57
58 PROCEDURE Generate_RPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB);
59 PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
60 p_rpa_misc_fields t_rpa_misc_fields_rec,
61 p_signature_rec t_signature_rec);
62 PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
63 p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);
64 PROCEDURE WritetoXML(p_report_name IN VARCHAR2,
65 p_xml_string OUT NOCOPY CLOB);
66
67 /**************************************For Populating NPA **************************************/
68 TYPE t_npa_misc_fields IS RECORD
69 (
70 appropriation_code varchar2(100),
71 from_position_org_lines VARCHAR2(1000),
72 sf50_approval_date VARCHAR2(15),
73 approval_date VARCHAR2(15),
74 employee_name VARCHAR2(200),
75 to_position_org_lines VARCHAR2(1000),
76 veterance_preference_for_rif_y VARCHAR2(1),
77 veterance_preference_for_rif_n VARCHAR2(1),
78 remarks_concat VARCHAR2(1000),
79 agency_code_use VARCHAR2(250),
80 agency_data40 VARCHAR2(250),
81 agency_data41 VARCHAR2(250),
82 agency_data42 VARCHAR2(250),
83 agency_data43 VARCHAR2(250),
84 agency_data44 VARCHAR2(250),
85 emp_dept_or_agency VARCHAR2(250),
86 from_tot_sal_or_awd VARCHAR2(50),
87 to_tot_sal_or_awd VARCHAR2(50)
88 );
89
90 TYPE t_npa_misc_fields_rec IS TABLE OF t_npa_misc_fields INDEX BY BINARY_INTEGER;
91
92 PROCEDURE Generate_NPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB);
93 PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
94 p_npa_misc_fields t_npa_misc_fields_rec);
95 PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
96 p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);
97 PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB);
98 PROCEDURE Debug(p_id NUMBER, p_statement VARCHAR2);
99
100 END GHR_GEN_RPA_NPA;