[Home] [Help]
PACKAGE BODY: APPS.OZF_DRILLDOWN_PUB_PKG
Source
1 PACKAGE BODY OZF_DRILLDOWN_PUB_PKG AS
2 /* $Header: ozfpdrlb.pls 120.1 2010/09/14 12:00:52 bkunjan noship $ */
3
4 ---------------------------------------------------------------------
5 -- API Name
6 -- DRILLDOWN
7 --Type
8 -- Public
9 -- PURPOSE
10 -- This procedure procedure provides a public API for sla to return
11 -- the appropriate information via OUT parameters to open the
12 -- appropriate transaction form.
13 -- PARAMETERS
14 -- p_application_id : Subledger application internal identifier
15 -- p_ledger_id : Event ledger identifier
16 -- p_legal_entity_id : Legal entity identifier
17 -- p_entity_code : Event entity internal code
18 -- p_event_class_code : Event class internal code
19 -- p_event_type_code : Event type internal code
20 -- p_source_id_int_1 : Generic system transaction identifiers
21 -- p_source_id_int_2 : Generic system transaction identifiers
22 -- p_source_id_int_3 : Generic system transaction identifiers
23 -- p_source_id_int_4 : Generic system transaction identifiers
24 -- p_source_id_char_1 : Generic system transaction identifiers
25 -- p_source_id_char_2 : Generic system transaction identifiers
26 -- p_source_id_char_3 : Generic system transaction identifiers
27 -- p_source_id_char_4 : Generic system transaction identifiers
28 -- p_security_id_int_1 : Generic system transaction identifiers
29 -- p_security_id_int_2 : Generic system transaction identifiers
30 -- p_security_id_int_3 : Generic system transaction identifiers
31 -- p_security_id_char_1 : Generic system transaction identifiers
32 -- p_security_id_char_2 : Generic system transaction identifiers
33 -- p_security_id_char_3 : Generic system transaction identifiers
34 -- p_valuation_method : Valuation Method internal identifier
35 -- p_user_interface_type: This parameter determines the user interface type.
36 -- The possible values are FORM, HTML, or NONE.
37 -- p_function_name : The name of the Oracle Application Object
38 -- Library function defined to open the transaction
39 -- form. This parameter is used only if the page
40 -- is a FORM page.
41 -- p_parameters : An Oracle Application Object Library Function
42 -- can have its own arguments/parameters. SLA
43 -- expects developers to return these arguments via
44 -- p_parameters.
45 -- NOTES
46 --
47 ---------------------------------------------------------------------
48 PROCEDURE DRILLDOWN(
49 p_application_id IN INTEGER
50 ,p_ledger_id IN INTEGER
51 ,p_legal_entity_id IN INTEGER DEFAULT NULL
52 ,p_entity_code IN VARCHAR2
53 ,p_event_class_code IN VARCHAR2
54 ,p_event_type_code IN VARCHAR2
55 ,p_source_id_int_1 IN INTEGER DEFAULT NULL
56 ,p_source_id_int_2 IN INTEGER DEFAULT NULL
57 ,p_source_id_int_3 IN INTEGER DEFAULT NULL
58 ,p_source_id_int_4 IN INTEGER DEFAULT NULL
59 ,p_source_id_char_1 IN VARCHAR2 DEFAULT NULL
60 ,p_source_id_char_2 IN VARCHAR2 DEFAULT NULL
61 ,p_source_id_char_3 IN VARCHAR2 DEFAULT NULL
62 ,p_source_id_char_4 IN VARCHAR2 DEFAULT NULL
63 ,p_security_id_int_1 IN INTEGER DEFAULT NULL
64 ,p_security_id_int_2 IN INTEGER DEFAULT NULL
65 ,p_security_id_int_3 IN INTEGER DEFAULT NULL
66 ,p_security_id_char_1 IN VARCHAR2 DEFAULT NULL
67 ,p_security_id_char_2 IN VARCHAR2 DEFAULT NULL
68 ,p_security_id_char_3 IN VARCHAR2 DEFAULT NULL
69 ,p_valuation_method IN VARCHAR2 DEFAULT NULL
70 ,p_user_interface_type IN OUT NOCOPY VARCHAR2
71 ,p_function_name IN OUT NOCOPY VARCHAR2
72 ,p_parameters IN OUT NOCOPY VARCHAR2
73 )
74 IS
75
76 l_fund_id NUMBER;
77 l_custom_setup_id NUMBER;
78 l_org_id NUMBER;
79
80 BEGIN
81
82 p_user_interface_type := 'HTML';
83
84 IF (p_event_class_code = 'ACCRUAL') THEN
85
86 SELECT fund.fund_id, fund.custom_setup_id
87 INTO l_fund_id, l_custom_setup_id
88 FROM ozf_funds_utilized_all_b util, ozf_funds_all_b fund
89 WHERE util.utilization_id = p_source_id_int_1
90 AND util.fund_id = fund.fund_id;
91
92 IF p_event_type_code = 'PAID_ADJUSTMENT' THEN --navigate to Budget Paid Checkbook UI
93
94 p_parameters := '/OA_HTML/OA.jsp?OAFunc=OZF_FUND_PAIDCHK&PAGE.OBJ.ID_NAME0=objId&PAGE.OBJ.ID0=' || l_fund_id ||
95 '&PAGE.OBJ.objType=FUND&PAGE.OBJ.ID_NAME1=utilizationId&PAGE.OBJ.ID1=' || p_source_id_int_1;
96
97 ELSE --navigate to Budget Earned Checkbook UI
98
99 p_parameters := '/OA_HTML/OA.jsp?OAFunc=OZF_FUND_EARNCHK&PAGE.OBJ.ID_NAME0=objId&PAGE.OBJ.ID0=' || l_fund_id ||
100 '&PAGE.OBJ.ID_NAME1=customSetupId&PAGE.OBJ.ID1=' || l_custom_setup_id ||
101 '&PAGE.OBJ.objType=FUND&PAGE.OBJ.ID_NAME2=utilizationId&PAGE.OBJ.ID2=' || p_source_id_int_1;
102
103 END IF;
104
105 ELSIF (p_event_class_code = 'CLAIM_SETTLEMENT') THEN --navigate to Claim Detail UI
106
107 SELECT custom_setup_id, org_id
108 INTO l_custom_setup_id, l_org_id
109 FROM ozf_claims_all
110 WHERE claim_id = p_source_id_int_1;
111
112 p_parameters := '/OA_HTML/OA.jsp?OAFunc=OZF_CLAM_DETL&PAGE.OBJ.ID_NAME0=objId&PAGE.OBJ.ID0=' || p_source_id_int_1 ||
113 '&PAGE.OBJ.objType=CLAM&PAGE.OBJ.objAttribute=DETL&PAGE.OBJ.ID_NAME1=customSetupId&PAGE.OBJ.ID1=' || l_custom_setup_id ||
114 '&PAGE.OBJ.ID_NAME2=orgId&PAGE.OBJ.ID2=' || l_org_id;
115
116 END IF;
117
118 EXCEPTION
119 WHEN OTHERS THEN
120 NULL;
121
122 END DRILLDOWN;
123 ---------------------------------------------------------------------
124 END OZF_DRILLDOWN_PUB_PKG;