DBA Data[Home] [Help]

APPS.GHR_GEN_RPA_NPA dependencies on GHR_PA_REQUESTS

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

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,

Line 59: PROCEDURE Populate_RPAtags(p_pa_request_rec 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);

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

Line 63: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);

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

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

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

Line 93: PROCEDURE Populate_NPAtags(p_pa_request_rec IN 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);

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

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:

Line 96: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype);

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;