DBA Data[Home] [Help]

PACKAGE: APPS.PO_ENCUMBRANCE_POSTPROCESSING

Source


1 PACKAGE PO_ENCUMBRANCE_POSTPROCESSING AS
2 -- $Header: POXENC2S.pls 120.5 2006/12/05 14:14:32 asista noship $
3 
4 -- Package constants
5 g_REPORT_LEVEL_TRANSACTION  CONSTANT VARCHAR2(15) := 'TRANSACTION';
6 g_REPORT_LEVEL_DISTRIBUTION CONSTANT VARCHAR2(15) := 'DISTRIBUTION';
7 
8 
9 -- Procedures used by PO_DOCUMENT_FUNDS_PVT.do_action:
10 
11 PROCEDURE insert_packet(
12   p_status_code                    IN             VARCHAR2
13 , p_user_id                        IN             NUMBER
14 , p_set_of_books_id                IN             NUMBER
15 , p_currency_code                  IN             VARCHAR2
16 , p_action                         IN             VARCHAR2
17 , x_packet_id                      OUT NOCOPY     NUMBER
18 );
19 
20 PROCEDURE execute_gl_call(
21   p_set_of_books_id                IN             NUMBER
22 , p_packet_id                      IN OUT NOCOPY  NUMBER
23 , p_gl_mode                        IN             VARCHAR2
24 , p_partial_resv_flag              IN             VARCHAR2
25 , p_override                       IN             VARCHAR2
26 , p_conc_flag                      IN             VARCHAR2
27 , p_user_id                        IN             NUMBER
28 , p_user_resp_id                   IN             NUMBER
29 , x_return_code                    OUT NOCOPY     VARCHAR2
30 );
31 
32 PROCEDURE copy_detailed_gl_results(
33   p_packet_id                      IN             NUMBER
34 , p_gl_return_code                 IN             VARCHAR2
35 );
36 
37 PROCEDURE update_document_encumbrance(
38   p_doc_type                       IN             VARCHAR2
39 , p_doc_subtype                    IN             VARCHAR2
40 , p_action                         IN             VARCHAR2
41 , p_gl_return_code                 IN             VARCHAR2
42 );
43 
44 PROCEDURE create_enc_action_history(
45    p_doc_type                       IN             VARCHAR2
46 ,  p_doc_id_tbl                     IN             po_tbl_number
47 ,  p_employee_id                    IN             NUMBER
48 ,  p_action                         IN             VARCHAR2
49 ,  p_cbc_flag                       IN             VARCHAR2
50 );
51 
52 PROCEDURE set_status_requires_reapproval(
53    p_document_type	IN	VARCHAR2
54 ,  p_action		IN	VARCHAR2
55 ,  p_cbc_flag           IN      VARCHAR2
56 );
57 
58 PROCEDURE create_detailed_report(
59    p_gl_return_code		IN		VARCHAR2
60 ,  p_user_id			IN		NUMBER
61 ,  x_online_report_id		OUT NOCOPY	VARCHAR2
62 ,  x_po_return_code		OUT NOCOPY	VARCHAR2
63 ,  x_po_return_msg_name		OUT NOCOPY	VARCHAR2
64 );
65 
66 
67 PROCEDURE create_exception_report(
68    p_message_text		IN		VARCHAR2
69 ,  p_user_id			IN		NUMBER
70 ,  x_online_report_id		OUT NOCOPY	NUMBER
71 );
72 
73 PROCEDURE delete_packet_autonomous(
74   p_packet_id                      IN     NUMBER
75 );
76 --<bug#5010001 START>
77 PROCEDURE populate_bc_report_id(
78     p_online_report_id IN NUMBER
79 );
80 --<bug#5010001 END>
81 --<bug#5523323 START>
82 --Removed the procedure populate_aut_bc_report_id. We do not
83 --have any autonomous transactions anymore.
84 --<bug#5523323 END>
85 --<bug#5353223 START>
86 FUNCTION get_sign_for_amount(p_event_type_code     IN VARCHAR2,
87                              p_main_or_backing_doc IN VARCHAR2,
88                              p_adjustment_status   IN VARCHAR2,
89                              p_distribution_type   IN VARCHAR2) RETURN NUMBER;
90 --<bug#5353223 END>
91 
92 END PO_ENCUMBRANCE_POSTPROCESSING;