1 PACKAGE PO_ENCUMBRANCE_POSTPROCESSING AUTHID CURRENT_USER AS
2 -- $Header: POXENC2S.pls 120.8.12020000.3 2013/03/05 01:55:59 pla ship $
3
4 -- Package constants
5 g_REPORT_LEVEL_TRANSACTION CONSTANT VARCHAR2(15) := 'TRANSACTION';
6 g_REPORT_LEVEL_DISTRIBUTION CONSTANT VARCHAR2(15) := 'DISTRIBUTION';
7 --<Bug 12824154 BEGIN >--
8 g_EXECUTE_GL_CALL_API_EXC exception;
9 g_event_id number;
10 --<Bug 12824154 END >--
11
12
13 -- Procedures used by PO_DOCUMENT_FUNDS_PVT.do_action:
14
15 PROCEDURE insert_packet(
16 p_status_code IN VARCHAR2
17 , p_user_id IN NUMBER
18 , p_set_of_books_id IN NUMBER
19 , p_currency_code IN VARCHAR2
20 , p_action IN VARCHAR2
21 , x_packet_id OUT NOCOPY NUMBER
22 );
23
24 PROCEDURE execute_gl_call(
25 p_set_of_books_id IN NUMBER
26 , p_packet_id IN OUT NOCOPY NUMBER
27 , p_gl_mode IN VARCHAR2
28 , p_partial_resv_flag IN VARCHAR2
29 , p_override IN VARCHAR2
30 , p_conc_flag IN VARCHAR2
31 , p_user_id IN NUMBER
32 , p_user_resp_id IN NUMBER
33 , x_return_code OUT NOCOPY VARCHAR2
34 );
35
36 PROCEDURE copy_detailed_gl_results(
37 p_packet_id IN NUMBER
38 , p_gl_return_code IN VARCHAR2
39 );
40
41 PROCEDURE update_document_encumbrance(
42 p_doc_type IN VARCHAR2
43 , p_doc_subtype IN VARCHAR2
44 , p_action IN VARCHAR2
45 , p_gl_return_code IN VARCHAR2
46 );
47
48 PROCEDURE create_enc_action_history(
49 p_doc_type IN VARCHAR2
50 , p_doc_id_tbl IN po_tbl_number
51 , p_employee_id IN NUMBER
52 , p_action IN VARCHAR2
53 , p_cbc_flag IN VARCHAR2
54 );
55
56 PROCEDURE set_status_requires_reapproval(
57 p_document_type IN VARCHAR2
58 , p_action IN VARCHAR2
59 , p_cbc_flag IN VARCHAR2
60 );
61
62 PROCEDURE create_detailed_report(
63 p_gl_return_code IN VARCHAR2
64 , p_user_id IN NUMBER
65 , x_online_report_id OUT NOCOPY VARCHAR2
66 , x_po_return_code OUT NOCOPY VARCHAR2
67 , x_po_return_msg_name OUT NOCOPY VARCHAR2
68 );
69
70
71 PROCEDURE create_exception_report(
72 p_message_text IN VARCHAR2
73 , p_user_id IN NUMBER
74 , x_online_report_id OUT NOCOPY NUMBER
75 );
76
77 PROCEDURE delete_packet_autonomous(
78 p_packet_id IN NUMBER
79 );
80 --<bug#5010001 START>
81 PROCEDURE populate_bc_report_id(
82 p_online_report_id IN NUMBER
83 );
84
85 /*12405805
86 Added to delete
87 1) Unprocessed events because of checkfunds
88 2)Invalid events because of exceptions
89 at the end of encumbrance action*/
90 PROCEDURE delete_unnecessary_events(
91 p_packet_id IN NUMBER,
92 p_action IN VARCHAR2
93
94 );
95 --<bug#5010001 END>
96 --<bug#5523323 START>
97 --Removed the procedure populate_aut_bc_report_id. We do not
98 --have any autonomous transactions anymore.
99 --<bug#5523323 END>
100 --<bug#5353223 START>
101 FUNCTION get_sign_for_amount(p_event_type_code IN VARCHAR2,
102 p_main_or_backing_doc IN VARCHAR2,
103 p_adjustment_status IN VARCHAR2,
104 p_distribution_type IN VARCHAR2) RETURN NUMBER;
105 --<bug#5353223 END>
106
107 -- <Bug 13503748: Edit without unreserve ER.>
108 -- Adding this function in the spec and removing private function
109 -- definition from the body.
110 FUNCTION get_event_type_code(p_distribution_type IN VARCHAR2,
111 p_action IN VARCHAR2) RETURN VARCHAR2;
112
113
114 END PO_ENCUMBRANCE_POSTPROCESSING;