1 PACKAGE AP_SLA_PROCESSING_PKG AUTHID CURRENT_USER AS
2 /* $Header: apslapps.pls 120.5 2006/07/19 19:02:47 hredredd noship $ */
3
4 PROCEDURE preaccounting
5 (
6 p_application_id IN NUMBER,
7 p_ledger_id IN INTEGER,
8 p_process_category IN VARCHAR2,
9 p_end_date IN DATE,
10 p_accounting_mode IN VARCHAR2,
11 p_valuation_method IN VARCHAR2,
12 p_security_id_int_1 IN INTEGER,
13 p_security_id_int_2 IN INTEGER,
14 p_security_id_int_3 IN INTEGER,
15 p_security_id_char_1 IN VARCHAR2,
16 p_security_id_char_2 IN VARCHAR2,
17 p_security_id_char_3 IN VARCHAR2,
18 p_report_request_id IN INTEGER
19 );
20
21 PROCEDURE extract
22 (
23 p_application_id IN NUMBER,
24 p_accounting_mode IN VARCHAR2
25 );
26
27
28 PROCEDURE postprocessing
29 (
30 p_application_id IN NUMBER,
31 p_accounting_mode IN VARCHAR2
32 );
33
34 PROCEDURE postaccounting
35 (
36 p_application_id IN NUMBER,
37 p_ledger_id IN INTEGER,
38 p_process_category IN VARCHAR2,
39 p_end_date IN DATE,
40 p_accounting_mode IN VARCHAR2,
41 p_valuation_method IN VARCHAR2,
42 p_security_id_int_1 IN INTEGER,
43 p_security_id_int_2 IN INTEGER,
44 p_security_id_int_3 IN INTEGER,
45 p_security_id_char_1 IN VARCHAR2,
46 p_security_id_char_2 IN VARCHAR2,
47 p_security_id_char_3 IN VARCHAR2,
48 p_report_request_id IN INTEGER
49 );
50
51 FUNCTION Derive_Cash_Posted_Flag
52 (P_event_id IN NUMBER
53 ,P_distribution_id IN NUMBER
54 ,P_dist_amount IN NUMBER
55 ,P_calling_sequence IN VARCHAR2
56 ) RETURN VARCHAR2;
57
58
59 FUNCTION Get_Amt_Already_Accounted
60 (P_event_id IN NUMBER
61 ,P_invoice_payment_id IN NUMBER
62 ,P_invoice_distribution_id IN NUMBER
63 ,P_calling_sequence IN VARCHAR2
64 ) RETURN NUMBER;
65
66 END ap_sla_processing_pkg;