1 PACKAGE AP_TRIAL_BALANCE_PKG AUTHID CURRENT_USER AS
2 /* $Header: aptrbals.pls 120.1 2004/10/29 19:05:56 pjena noship $ */
3
4 TYPE transfer_run_id IS TABLE OF
5 xla_gl_transfer_batches_all.gl_transfer_run_id%TYPE
6 INDEX BY BINARY_INTEGER;
7
8 FUNCTION Process_Trial_Balance (
9 p_accounting_date IN DATE,
10 p_from_date IN DATE,
11 p_request_id IN NUMBER,
12 p_reporting_entity_id IN NUMBER,
13 p_org_where_alb IN VARCHAR2,
14 p_org_where_ael IN VARCHAR2,
15 p_org_where_asp IN VARCHAR2,
16 p_neg_bal_only IN VARCHAR2,
17 p_debug_switch IN VARCHAR2)
18 RETURN BOOLEAN;
19
20 FUNCTION Insert_AP_Trial_Bal (
21 p_accounting_date IN DATE,
22 p_from_date IN DATE,
23 p_request_id IN NUMBER,
24 p_reporting_entity_id IN NUMBER,
25 p_org_where_alb IN VARCHAR2,
26 p_org_where_ael IN VARCHAR2,
27 p_debug_switch IN VARCHAR2)
28 RETURN BOOLEAN;
29
30 FUNCTION Insert_AP_Trial_Bal (
31 p_accounting_date IN DATE,
32 p_request_id IN NUMBER,
33 p_reporting_entity_id IN NUMBER,
34 p_org_where_alb IN VARCHAR2,
35 p_org_where_ael IN VARCHAR2,
36 p_debug_switch IN VARCHAR2)
37 RETURN BOOLEAN;
38
39 FUNCTION Insert_Future_Dated (
40 p_accounting_date IN DATE,
41 p_from_date IN DATE,
42 p_request_id IN NUMBER,
43 p_reporting_entity_id IN NUMBER,
44 p_org_where_ael IN VARCHAR2,
45 p_debug_switch IN VARCHAR2)
46 RETURN BOOLEAN;
47
48 FUNCTION Insert_Future_Dated (
49 p_accounting_date IN DATE,
50 p_request_id IN NUMBER,
51 p_reporting_entity_id IN NUMBER,
52 p_org_where_ael IN VARCHAR2,
53 p_debug_switch IN VARCHAR2)
54 RETURN BOOLEAN;
55
56 FUNCTION Process_Neg_Bal (
57 p_request_id IN NUMBER)
58 RETURN BOOLEAN;
59
60
61 FUNCTION Use_Future_Dated (
62 p_org_where_asp IN VARCHAR2,
63 p_debug_switch IN VARCHAR2)
64 RETURN BOOLEAN;
65
66 FUNCTION Insert_AP_Liability_Balance (
67 p_request_id IN NUMBER,
68 p_user_id IN NUMBER,
69 p_resp_appl_id IN NUMBER,
70 p_login_id IN NUMBER,
71 p_program_id IN NUMBER,
72 p_program_appl_id IN NUMBER)
73 RETURN BOOLEAN;
74
75 FUNCTION Update_Trial_Balance_Flag (
76 p_gl_transfer_run_id IN NUMBER)
77 RETURN BOOLEAN;
78
79 FUNCTION Is_Reporting_Books (
80 p_set_of_books_id IN NUMBER)
81 RETURN BOOLEAN;
82
83 FUNCTION Get_Base_Currency_Code (
84 p_set_of_books_id IN NUMBER)
85 RETURN VARCHAR2;
86
87 FUNCTION Get_Invoice_Amount (
88 p_set_of_books_id IN NUMBER,
89 p_invoice_id IN NUMBER,
90 p_invoice_amount IN NUMBER,
91 p_exchange_rate IN NUMBER)
92 RETURN NUMBER;
93
94
95 END AP_TRIAL_BALANCE_PKG;