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,
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);
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:
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 **************************************/
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);
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);
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:
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;