1 PACKAGE PSP_XMLGEN AS
2 /* $Header: PSPXMLGS.pls 120.4.12010000.1 2008/07/28 08:12:55 appldev ship $ */
3 FUNCTION generate_approver_header_xml (p_request_id IN NUMBER DEFAULT NULL) RETURN CLOB;
4 FUNCTION generate_approver_xml (p_wf_item_key IN NUMBER,
5 p_request_id IN NUMBER DEFAULT NULL) RETURN CLOB;
6 FUNCTION generate_person_xml (p_person_id IN NUMBER,
7 p_template_id IN NUMBER,
8 p_effort_report_id IN NUMBER,
9 p_request_id IN NUMBER,
10 p_set_of_books_id IN NUMBER,
11 p_full_name IN VARCHAR2,
12 p_employee_number IN VARCHAR2,
13 p_mailstop IN VARCHAR2,
14 p_emp_primary_org_name IN VARCHAR2,
15 p_emp_primary_org_id IN NUMBER,
16 p_currency_code IN VARCHAR2 ) RETURN CLOB;
17
18 PROCEDURE store_pdf (p_wf_item_key IN NUMBER,
19 p_receiver_flag IN VARCHAR2,
20 p_file_id OUT NOCOPY NUMBER,
21 p_wf_Role_Name IN VARCHAR2);
22
23 PROCEDURE attach_pdf (p_item_type_key IN VARCHAR2,
24 content_type IN VARCHAR2,
25 p_document IN OUT NOCOPY BLOB,
26 p_document_type IN OUT NOCOPY VARCHAR2);
27
28 PROCEDURE update_er_person_xml (p_start_person IN NUMBER,
29 p_end_person IN NUMBER,
30 p_request_id IN NUMBER,
31 p_retry_request_id IN NUMBER DEFAULT NULL,
32 p_return_status OUT NOCOPY VARCHAR2);
33
34 PROCEDURE update_er_person_xml (p_request_id IN NUMBER,
35 p_return_status OUT NOCOPY VARCHAR2);
36
37 PROCEDURE update_er_person_xml (p_wf_item_key IN NUMBER,
38 p_return_status OUT NOCOPY VARCHAR2);
39
40 PROCEDURE update_er_details (p_start_person IN NUMBER,
41 p_end_person IN NUMBER,
42 p_request_id IN NUMBER,
43 p_retry_request_id IN NUMBER DEFAULT NULL,
44 p_return_status OUT NOCOPY VARCHAR2);
45 PROCEDURE COPY_PTAOE_FROM_GL_SEGMENTS (p_start_person IN NUMBER,
46 p_end_person IN NUMBER,
47 p_request_id IN NUMBER,
48 p_retry_request_id IN NUMBER DEFAULT NULL,
49 p_business_group_id IN NUMBER,
50 p_return_status OUT NOCOPY VARCHAR2);
51 function convert_xml_controls(p_string varchar2) return varchar2; --- added for uva issues .. 4429787
52
53 PROCEDURE update_er_error_details (p_request_id IN NUMBER,
54 p_retry_request_id IN NUMBER,
55 p_return_status OUT NOCOPY VARCHAR2);
56
57
58 /* Procedure Added for Hospital effort report */
59
60 PROCEDURE update_grouping_category ( p_start_person IN NUMBER,
61 p_end_person IN NUMBER,
62 p_request_id IN NUMBER,
63 p_return_status OUT NOCOPY VARCHAR2) ;
64 END PSP_XMLGEN;