1 PACKAGE IGC_DRILLDOWN_PUB_PKG AUTHID CURRENT_USER AS
2 /*$Header: IGCSLADS.pls 120.2.12000000.1 2007/10/25 09:19:58 mbremkum 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 END IGC_DRILLDOWN_PUB_PKG;