[Home] [Help]
PACKAGE: APPS.GHR_GEN_RPA_NPA
Source
1 PACKAGE GHR_GEN_RPA_NPA AUTHID CURRENT_USER AS
2 /* $Header: ghgenpa.pkh 120.0.12020000.5 2012/07/05 14:27:26 amnaraya 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
10
11 TYPE remarks_wrapped IS TABLE OF VARCHAR2 (145)
12 INDEX BY BINARY_INTEGER;
13
14 PROCEDURE wrap_text
15 (remark_in IN VARCHAR2,
16 line_length IN NUMBER,
17 wrap_out IN OUT NOCOPY remarks_wrapped,
18 word_delimiter IN VARCHAR2 := ' ');
19
20
21 TYPE t_rpa_misc_fields IS RECORD
22 (
23 action_requested GHR_FAMILIES.NAME%TYPE,
24 additional_info_name VARCHAR2(200),
25 requested_by VARCHAR2(200),
26 authorized_by VARCHAR2(200),
27 employee_name VARCHAR2(200),
28 appropriation_code varchar2(100),
29 from_position_org_lines VARCHAR2(1000),
30 to_position_org_lines VARCHAR2(1000),
31 agency_code_use VARCHAR2(250),
32 agency_data40 VARCHAR2(250),
33 agency_data41 VARCHAR2(250),
34 agency_data42 VARCHAR2(250),
35 agency_data43 VARCHAR2(250),
36 agency_data44 VARCHAR2(250),
37 veterance_preference_for_rif_y VARCHAR2(1),
38 veterance_preference_for_rif_n VARCHAR2(1),
39 requesting_office_rem_flag_y VARCHAR2(1),
40 requesting_office_rem_flag_n VARCHAR2(1),
41 forwarding_city VARCHAR2(1000),
42 remarks_concat VARCHAR2(2000),
43 from_tot_sal_or_awd VARCHAR2(50),
44 to_tot_sal_or_awd VARCHAR2(50)
45 );
46
47 TYPE t_remarks IS RECORD
48 (
49 remarks_desc ghr_pa_remarks.description%type,
50 remark_code ghr_remarks.code%type);
51
52 -- Type for RPA/NPA Tags
53 TYPE t_report_tags IS RECORD
54 (
55 tag_name VARCHAR2(50),
56 par_field_value VARCHAR2(5000));
57
58 TYPE t_signatures IS RECORD
59 (
60 office_function varchar2(100),
61 office_signature varchar2(100),
62 office_date varchar2(100));
63
64 /**************************************For Populating RPA **************************************/
65 TYPE t_rpa_misc_fields_rec IS TABLE OF t_rpa_misc_fields INDEX BY BINARY_INTEGER;
66 TYPE t_report_tags_rec IS TABLE OF t_report_tags INDEX BY BINARY_INTEGER;
67 TYPE t_signature_rec IS TABLE OF t_signatures INDEX BY BINARY_INTEGER;
68 TYPE t_remarks_rec IS TABLE OF t_remarks INDEX BY BINARY_INTEGER;
69
70 PROCEDURE Generate_RPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB);
71 PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
72 p_rpa_misc_fields t_rpa_misc_fields_rec,
73 p_signature_rec t_signature_rec,
74 p_conti_remarks_concat varchar2,
75 p_displayCRemarks varchar2);
76 PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
77 p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);
78 PROCEDURE WritetoXML(p_report_name IN VARCHAR2,
79 p_xml_string OUT NOCOPY CLOB);
80
81 /**************************************For Populating NPA **************************************/
82 TYPE t_npa_misc_fields IS RECORD
83 (
84 appropriation_code varchar2(100),
85 from_position_org_lines VARCHAR2(1000),
86 sf50_approval_date VARCHAR2(15),
87 approval_date VARCHAR2(15),
88 employee_name VARCHAR2(200),
89 to_position_org_lines VARCHAR2(1000),
90 veterance_preference_for_rif_y VARCHAR2(1),
91 veterance_preference_for_rif_n VARCHAR2(1),
92 remarks_concat VARCHAR2(2000),
93 agency_code_use VARCHAR2(250),
94 agency_data40 VARCHAR2(250),
95 agency_data41 VARCHAR2(250),
96 agency_data42 VARCHAR2(250),
97 agency_data43 VARCHAR2(250),
98 agency_data44 VARCHAR2(250),
99 emp_dept_or_agency VARCHAR2(250),
100 from_tot_sal_or_awd VARCHAR2(50),
101 to_tot_sal_or_awd VARCHAR2(50)
102 );
103
104 TYPE t_npa_misc_fields_rec IS TABLE OF t_npa_misc_fields INDEX BY BINARY_INTEGER;
105
106 PROCEDURE Generate_NPA(p_pa_request_id ghr_pa_requests.pa_request_id%type, p_view_type VARCHAR2, p_xml_string OUT NOCOPY CLOB);
107 PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,
108 p_npa_misc_fields t_npa_misc_fields_rec);
109 PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
110 p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);
111 PROCEDURE Get_Template(p_program_name fnd_lobs.program_name%type, p_template OUT NOCOPY BLOB);
112 PROCEDURE Debug(p_id NUMBER, p_statement VARCHAR2);
113
114 END GHR_GEN_RPA_NPA;