[Home] [Help]
PACKAGE: APPS.PSA_AP_BC_PVT
Source
1 PACKAGE PSA_AP_BC_PVT AUTHID CURRENT_USER AS
2 --$Header: psavapbs.pls 120.17.12020000.1 2012/06/26 13:09:52 appldev ship $
3
4 ---------------------------------------------------------------------------
5
6 g_debug_mode VARCHAR2(1):= 'N';
7
8 TYPE Funds_Dist_Rec IS RECORD
9 (
10 invoice_id AP_INVOICES.invoice_id%TYPE,
11 invoice_num AP_INVOICES.invoice_num%TYPE,
12 legal_entity_id AP_INVOICES.legal_entity_id%TYPE,
13 invoice_type_code AP_INVOICES.invoice_type_lookup_code%TYPE,
14 inv_line_num AP_INVOICE_DISTRIBUTIONS.invoice_line_number%TYPE,
15 inv_distribution_id AP_INVOICE_DISTRIBUTIONS.invoice_distribution_id%TYPE,
16 accounting_date AP_INVOICE_DISTRIBUTIONS.accounting_date%TYPE,
17 distribution_type AP_INVOICE_DISTRIBUTIONS_ALL.LINE_TYPE_LOOKUP_CODE%TYPE,
18 distribution_amount AP_INVOICE_DISTRIBUTIONS_ALL.AMOUNT%TYPE,
19 set_of_books_id AP_INVOICE_DISTRIBUTIONS.set_of_books_id%TYPE,
20 bc_event_id AP_INVOICE_DISTRIBUTIONS.bc_event_id%TYPE,
21 org_id AP_INVOICE_DISTRIBUTIONS.org_id%TYPE,
22 result_code GL_BC_PACKETS.result_code%TYPE,
23 status_code GL_BC_PACKETS.status_code%TYPE,
24 SELF_ASSESSED_FLAG ap_self_assessed_tax_dist_all.SELF_ASSESSED_FLAG%TYPE);
25 TYPE Funds_Dist_Tab_Type IS TABLE OF Funds_Dist_Rec INDEX BY BINARY_INTEGER;
26
27 ---------------------------------------------------------------------------
28
29 PROCEDURE Create_Events
30 (
31 p_init_msg_list IN VARCHAR2,
32 p_tab_fc_dist IN Funds_Dist_Tab_Type,
33 p_calling_mode IN VARCHAR2,
34 p_bc_mode IN VARCHAR2,
35 p_calling_sequence IN VARCHAR2,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 ---------------------------------------------------------------------------
42
43 PROCEDURE Delete_Events
44 (
45 p_init_msg_list IN VARCHAR2,
46 p_ledger_id IN NUMBER,
47 p_start_date IN DATE,
48 p_end_date IN DATE,
49 p_calling_sequence IN VARCHAR2,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2
53 );
54
55 ---------------------------------------------------------------------------
56
57 PROCEDURE delete_processed_orphan_events(
58 p_init_msg_list IN VARCHAR2,
59 p_ledger_id IN NUMBER,
60 p_calling_sequence IN VARCHAR2,
61 p_return_status OUT NOCOPY VARCHAR2,
62 p_msg_count OUT NOCOPY NUMBER,
63 p_msg_data OUT NOCOPY VARCHAR2
64 );
65 ---------------------------------------------------------------------------
66
67 PROCEDURE Get_Detailed_Results
68 (
69 p_init_msg_list IN VARCHAR2,
70 p_tab_fc_dist IN OUT NOCOPY Funds_Dist_Tab_Type,
71 p_calling_sequence IN VARCHAR2,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2
75 );
76
77 ---------------------------------------------------------------------------
78
79 PROCEDURE Get_GL_FundsChk_Result_Code
80 (
81 p_fc_result_code IN OUT NOCOPY VARCHAR2
82 );
83
84 ---------------------------------------------------------------------------
85
86 PROCEDURE Process_Fundschk_Failure_Code
87 (
88 p_invoice_id IN NUMBER,
89 p_inv_line_num IN NUMBER,
90 p_dist_line_num IN NUMBER,
91 p_return_message_name IN OUT NOCOPY VARCHAR2,
92 p_calling_sequence IN VARCHAR2
93 );
94
95 ---------------------------------------------------------------------------
96
97 PROCEDURE Reinstate_PO_Encumbrance
98 (
99 p_calling_mode IN VARCHAR2,
100 p_tab_fc_dist IN Funds_Dist_Tab_Type,
101 p_calling_sequence IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2
105 );
106
107 -----------------------------------------------------------------------------
108
109 FUNCTION Get_PO_Reversed_Encumb_Amount
110 (
111 P_po_distribution_id IN NUMBER,
112 P_start_gl_date IN DATE,
113 P_end_gl_date IN DATE,
114 P_calling_sequence IN VARCHAR2 DEFAULT NULL
115 ) RETURN NUMBER;
116
117 -----------------------------------------------------------------------------
118 FUNCTION isprepaydist
119 ( p_inv_dist_id IN NUMBER,
120 p_inv_id IN NUMBER,
121 p_dist_type IN VARCHAR2
122 ) RETURN VARCHAR2;
123 -------------------------------------------------------------------
124
125 END PSA_AP_BC_PVT;