[Home] [Help]
PACKAGE: APPS.PSA_AP_BC_PVT
Source
1 PACKAGE PSA_AP_BC_PVT AS
2 --$Header: psavapbs.pls 120.12.12010000.2 2008/08/04 07:16:44 cjain 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 Get_Detailed_Results
58 (
59 p_init_msg_list IN VARCHAR2,
60 p_tab_fc_dist IN OUT NOCOPY Funds_Dist_Tab_Type,
61 p_calling_sequence IN VARCHAR2,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2
65 );
66
67 ---------------------------------------------------------------------------
68
69 PROCEDURE Get_GL_FundsChk_Result_Code
70 (
71 p_fc_result_code IN OUT NOCOPY VARCHAR2
72 );
73
74 ---------------------------------------------------------------------------
75
76 PROCEDURE Process_Fundschk_Failure_Code
77 (
78 p_invoice_id IN NUMBER,
79 p_inv_line_num IN NUMBER,
80 p_dist_line_num IN NUMBER,
81 p_return_message_name IN OUT NOCOPY VARCHAR2,
82 p_calling_sequence IN VARCHAR2
83 );
84
85 ---------------------------------------------------------------------------
86
87 PROCEDURE Reinstate_PO_Encumbrance
88 (
89 p_calling_mode IN VARCHAR2,
90 p_tab_fc_dist IN Funds_Dist_Tab_Type,
91 p_calling_sequence IN VARCHAR2,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2
95 );
96
97 -----------------------------------------------------------------------------
98
99 FUNCTION Get_PO_Reversed_Encumb_Amount
100 (
101 P_po_distribution_id IN NUMBER,
102 P_start_gl_date IN DATE,
103 P_end_gl_date IN DATE,
104 P_calling_sequence IN VARCHAR2 DEFAULT NULL
105 ) RETURN NUMBER;
106
107 -----------------------------------------------------------------------------
108 FUNCTION isprepaydist
109 ( p_inv_dist_id IN NUMBER,
110 p_inv_id IN NUMBER,
111 p_dist_type IN VARCHAR2
112 ) RETURN VARCHAR2;
113 -------------------------------------------------------------------
114
115 END PSA_AP_BC_PVT;