APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUESTS

Line 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);

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,

Line 71: PROCEDURE Populate_RPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,

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);

Line 76: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in 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:

Line 77: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);

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 **************************************/

Line 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);

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);

Line 107: PROCEDURE Populate_NPAtags(p_pa_request_rec IN ghr_pa_requests%ROWTYPE,

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);

Line 109: PROCEDURE CondPrinting_NPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,

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:

Line 110: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);

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;