1 PACKAGE AP_DRILLDOWN_PUB_PKG AS
2 /* $Header: apsladrs.pls 120.1 2005/04/26 16:18:41 yicao noship $ */
3
4 /*============================================================================+
5 | PROCEDURE: DRILLDOWN
6 | COMMENT: DRILLDOWN procedure provides a public API for sla to return
7 | the appropriate information via OUT parameters to open the
8 | appropriate transaction form.
9 | PARAMETERS:
10 | p_application_id : Subledger application internal identifier
11 | p_ledger_id : Event ledger identifier
12 | p_legal_entity_id : Legal entity identifier
13 | p_entity_code : Event entity internal code
14 | p_event_class_code : Event class internal code
15 | p_event_type_code : Event type internal code
16 | p_source_id_int_1 : Generic system transaction identifiers
17 | p_source_id_int_2 : Generic system transaction identifiers
18 | p_source_id_int_3 : Generic system transaction identifiers
19 | p_source_id_int_4 : Generic system transaction identifiers
20 | p_source_id_char_1 : Generic system transaction identifiers
21 | p_source_id_char_2 : Generic system transaction identifiers
22 | p_source_id_char_3 : Generic system transaction identifiers
23 | p_source_id_char_4 : Generic system transaction identifiers
24 | p_security_id_int_1 : Generic system transaction identifiers
25 | p_security_id_int_2 : Generic system transaction identifiers
26 | p_security_id_int_3 : Generic system transaction identifiers
27 | p_security_id_char_1 : Generic system transaction identifiers
28 | p_security_id_char_2 : Generic system transaction identifiers
29 | p_security_id_char_3 : Generic system transaction identifiers
30 | p_valuation_method : Valuation Method internal identifier
31 | p_user_interface_type: This parameter determines the user interface type.
32 | The possible values are FORM, HTML, or NONE.
33 | p_function_name : The name of the Oracle Application Object
34 | Library function defined to open the transaction
35 | form. This parameter is used only if the page
36 | is a FORM page.
37 | p_parameters : An Oracle Application Object Library Function
38 | can have its own arguments/parameters. SLA
39 | expects developers to return these arguments via
40 | p_parameters.
41 |
42 +==========================================================================*/
43
44 PROCEDURE DRILLDOWN
45 (p_application_id IN INTEGER
46 ,p_ledger_id IN INTEGER
47 ,p_legal_entity_id IN INTEGER DEFAULT NULL
48 ,p_entity_code IN VARCHAR2
49 ,p_event_class_code IN VARCHAR2
50 ,p_event_type_code IN VARCHAR2
51 ,p_source_id_int_1 IN INTEGER DEFAULT NULL
52 ,p_source_id_int_2 IN INTEGER DEFAULT NULL
53 ,p_source_id_int_3 IN INTEGER DEFAULT NULL
54 ,p_source_id_int_4 IN INTEGER DEFAULT NULL
55 ,p_source_id_char_1 IN VARCHAR2 DEFAULT NULL
56 ,p_source_id_char_2 IN VARCHAR2 DEFAULT NULL
57 ,p_source_id_char_3 IN VARCHAR2 DEFAULT NULL
58 ,p_source_id_char_4 IN VARCHAR2 DEFAULT NULL
59 ,p_security_id_int_1 IN INTEGER DEFAULT NULL
60 ,p_security_id_int_2 IN INTEGER DEFAULT NULL
61 ,p_security_id_int_3 IN INTEGER DEFAULT NULL
62 ,p_security_id_char_1 IN VARCHAR2 DEFAULT NULL
63 ,p_security_id_char_2 IN VARCHAR2 DEFAULT NULL
64 ,p_security_id_char_3 IN VARCHAR2 DEFAULT NULL
65 ,p_valuation_method IN VARCHAR2 DEFAULT NULL
66 ,p_user_interface_type IN OUT NOCOPY VARCHAR2
67 ,p_function_name IN OUT NOCOPY VARCHAR2
68 ,p_parameters IN OUT NOCOPY VARCHAR2);
69
70
71 /*===========================================================================+
72 | PROCEDURE: INVOICE_ONLINE_ACCOUNTING
73 | COMMENT: Invoice_online_accounting procedure will call the SLA public
74 | API to process the oneline accounting for specific invoice
75 | PARAMETERS: p_invoice_id IN --the invoice will be accounted
76 | p_accounting_mode IN 'D' --Draft mode
77 | 'F' --Final mode
78 | 'P' --Final and post in general ledger
79 | p_errbuf OUT --Error message
80 | p_ret_code OUT --The retcode OUT prameter returns the
81 | success
82 | code back to the caller. If the call is
83 | completed successfully, the return value is
84 | 0(Zero)
85 |
86 +===========================================================================*/
87
88 PROCEDURE INVOICE_ONLINE_ACCOUNTING
89 (p_invoice_id IN NUMBER,
90 p_accounting_mode IN VARCHAR2,
91 p_errbuf OUT NOCOPY VARCHAR2,
92 p_retcode OUT NOCOPY NUMBER,
93 p_calling_sequence IN VARCHAR2);
94
95 /*===========================================================================+
96 | PROCEDURE: PAYMENT_ONLINE_ACCOUNTING
97 | COMMENT: Payment_online_accounting procedure will call the SLA public
98 | API to process the oneline accounting for specific invoice
99 | PARAMETERS: p_check_id IN --the invoice will be accounted
100 | p_accounting_mode IN 'D' --Draft mode
101 | 'F' --Final mode
102 | 'P' --Final and post in general ledger
103 | p_errbuf OUT --Error message
104 | p_ret_code OUT --The retcode OUT prameter returns
105 | the success code back to the caller.
106 | If the call is completed successfully
107 | the return value is 0(Zero)
108 |
109 +===========================================================================*/
110
111 PROCEDURE PAYMENT_ONLINE_ACCOUNTING
112 (p_check_id IN NUMBER,
113 p_accounting_mode IN VARCHAR2,
114 p_errbuf OUT NOCOPY VARCHAR2,
115 p_retcode OUT NOCOPY NUMBER,
116 p_calling_sequence IN VARCHAR2);
117
118 END AP_DRILLDOWN_PUB_PKG;
119