[Home] [Help]
PACKAGE BODY: APPS.FV_DRILLDOWN_PUB_PKG
Source
1 PACKAGE BODY FV_DRILLDOWN_PUB_PKG as
2 --$Header: fvsladrb.pls 120.4 2011/05/13 07:25:28 yanasing ship $
3 /*========================================================================
4 | PROCEDURE: DRILLDOWN
5 | COMMENT: DRILLDOWN procedure provides a public API for sla to return
6 | the appropriate information via OUT parameters to open the
7 | appropriate transaction form.
8 | PARAMETERS:
9 | p_application_id : Subledger application internal identifier
10 | p_ledger_id : Event ledger identifier
11 | p_legal_entity_id : Legal entity identifier
12 | p_entity_code : Event entity internal code
13 | p_event_class_code : Event class internal code
14 | p_event_type_code : Event type internal codess
15 | p_source_id_int_1 : Generic system transaction identifiers
16 | p_source_id_int_2 : Generic system transaction identifiers
17 | p_source_id_int_3 : Generic system transaction identifiers
18 | p_source_id_int_4 : Generic system transaction identifiers
19 | p_source_id_char_1 : Generic system transaction identifiers
20 | p_source_id_char_2 : Generic system transaction identifiers
21 | p_source_id_char_3 : Generic system transaction identifiers
22 | p_source_id_char_4 : Generic system transaction identifiers
23 | p_security_id_int_1 : Generic system transaction identifiers
24 | p_security_id_int_2 : Generic system transaction identifiers
25 | p_security_id_int_3 : Generic system transaction identifiers
26 | p_security_id_char_1 : Generic system transaction identifiers
27 | p_security_id_char_2 : Generic system transaction identifiers
28 | p_security_id_char_3 : Generic system transaction identifiers
29 | p_valuation_method : Valuation Method internal identifier
30 | p_user_interface_type: This parameter determines the user interface type.
31 | The possible values are FORM, HTML, or NONE.
32 | p_function_name : The name of the Oracle Application Object
33 | Library function defined to open the transaction
34 | form. This parameter is used only if the page
35 | is a FORM page.
36 | p_parameters : An Oracle Application Object Library Function
37 | can have its own arguments/parameters. SLA
38 | expects developers to return these arguments via
39 | p_parameters.
40 |
41 +===========================================================================*/
42
43 PROCEDURE DRILLDOWN
44 (p_application_id IN INTEGER
45 ,p_ledger_id IN INTEGER
46 ,p_legal_entity_id IN INTEGER DEFAULT NULL
47 ,p_entity_code IN VARCHAR2
48 ,p_event_class_code IN VARCHAR2
49 ,p_event_type_code IN VARCHAR2
50 ,p_source_id_int_1 IN INTEGER DEFAULT NULL
51 ,p_source_id_int_2 IN INTEGER DEFAULT NULL
52 ,p_source_id_int_3 IN INTEGER DEFAULT NULL
53 ,p_source_id_int_4 IN INTEGER DEFAULT NULL
54 ,p_source_id_char_1 IN VARCHAR2 DEFAULT NULL
55 ,p_source_id_char_2 IN VARCHAR2 DEFAULT NULL
56 ,p_source_id_char_3 IN VARCHAR2 DEFAULT NULL
57 ,p_source_id_char_4 IN VARCHAR2 DEFAULT NULL
58 ,p_security_id_int_1 IN INTEGER DEFAULT NULL
59 ,p_security_id_int_2 IN INTEGER DEFAULT NULL
60 ,p_security_id_int_3 IN INTEGER DEFAULT NULL
61 ,p_security_id_char_1 IN VARCHAR2 DEFAULT NULL
62 ,p_security_id_char_2 IN VARCHAR2 DEFAULT NULL
63 ,p_security_id_char_3 IN VARCHAR2 DEFAULT NULL
64 ,p_valuation_method IN VARCHAR2 DEFAULT NULL
65 ,p_user_interface_type IN OUT NOCOPY VARCHAR2
66 ,p_function_name IN OUT NOCOPY VARCHAR2
67 ,p_parameters IN OUT NOCOPY VARCHAR2)
68
69 IS
70
71 BEGIN
72
73 -- To check whether the application
74 IF (p_application_id =8901) THEN
75 IF(p_event_class_code = 'TREASURY_ACCOMPLISHMENT') THEN
76 p_user_interface_type := 'FORM';
77 p_function_name := 'XLA_FVXRTCRF';
78 p_parameters := ' TREASURY_CONFIRMATION_ID="' ||TO_CHAR(p_source_id_int_1)
79 ||'" FORM_USAGE_MODE="GL_DRILLDOWN" ';
80 ELSIF(p_event_class_code = 'BUDGET_EXECUTION') THEN
81 IF (p_event_type_code = 'BA_RESERVE') THEN
82 p_user_interface_type := 'FORM';
83 p_function_name := 'FV_FVXBEAPR';
84 p_parameters := ' QUERY_ONLY=Y" DOC_ID="' ||TO_CHAR(p_source_id_int_1)
85 ||'" FORM_USAGE_MODE="GL_DRILLDOWN" ';
86 ELSIF (p_event_type_code = 'FD_RESERVE') THEN
87 p_user_interface_type := 'FORM';
88 p_function_name := 'FV_FVXBEDFD';
89 p_parameters := ' QUERY_ONLY=Y" DOC_ID="' ||TO_CHAR(p_source_id_int_1)
90 ||'" FORM_USAGE_MODE="GL_DRILLDOWN" ';
91 END IF;
92 ELSIF(p_event_class_code = 'RPR_BUDGET_EXECUTION') THEN
93 IF (p_event_type_code IN ('RPR_BA_RESERVE', 'RPR_FD_RESERVE')) THEN
94 p_user_interface_type := 'FORM';
95 p_function_name := 'FV_FVXBERPR';
96 p_parameters := ' QUERY_ONLY=Y" TRANSACTION_ID="'||TO_CHAR(p_source_id_int_1)
97 ||'" FORM_USAGE_MODE="GL_DRILLDOWN" ';
98 END IF;
99
100 ELSE
101 p_user_interface_type :='NONE';
102 END IF;
103 END IF;
104
105 END DRILLDOWN;
106 END FV_DRILLDOWN_PUB_PKG;
107