[Home] [Help]
PACKAGE BODY: APPS.IGC_DRILLDOWN_PUB_PKG
Source
1 PACKAGE BODY IGC_DRILLDOWN_PUB_PKG AS
2 /*$Header: IGCSLADB.pls 120.2.12000000.1 2007/10/25 09:20:03 mbremkum noship $ */
3
4 -- Logging Infra
5 G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6 G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7 G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8 G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9 G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10 G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11 G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12 G_MODULE_NAME CONSTANT VARCHAR2(50) := 'IGC.PLSQL.IGC_DRILLDOWN_PUB_PKG.';
13 -- Logging Infra
14
15 /*========================================================================
16 | PROCEDURE: DRILLDOWN
17 | COMMENT: DRILLDOWN procedure provides a public API for sla to return
18 | the appropriate information via OUT parameters to open the
19 | appropriate transaction form.
20 | PARAMETERS:
21 | p_application_id : Subledger application internal identifier
22 | p_ledger_id : Event ledger identifier
23 | p_legal_entity_id : Legal entity identifier
24 | p_entity_code : Event entity internal code
25 | p_event_class_code : Event class internal code
26 | p_event_type_code : Event type internal code
27 | p_source_id_int_1 : Generic system transaction identifiers
28 | p_source_id_int_2 : Generic system transaction identifiers
29 | p_source_id_int_3 : Generic system transaction identifiers
30 | p_source_id_int_4 : Generic system transaction identifiers
31 | p_source_id_char_1 : Generic system transaction identifiers
32 | p_source_id_char_2 : Generic system transaction identifiers
33 | p_source_id_char_3 : Generic system transaction identifiers
34 | p_source_id_char_4 : Generic system transaction identifiers
35 | p_security_id_int_1 : Generic system transaction identifiers
36 | p_security_id_int_2 : Generic system transaction identifiers
37 | p_security_id_int_3 : Generic system transaction identifiers
38 | p_security_id_char_1 : Generic system transaction identifiers
39 | p_security_id_char_2 : Generic system transaction identifiers
40 | p_security_id_char_3 : Generic system transaction identifiers
41 | p_valuation_method : Valuation Method internal identifier
42 | p_user_interface_type: This parameter determines the user interface type.
43 | The possible values are FORM, HTML, or NONE.
44 | p_function_name : The name of the Oracle Application Object
45 | Library function defined to open the transaction
46 | form. This parameter is used only if the page
47 | is a FORM page.
48 | p_parameters : An Oracle Application Object Library Function
49 | can have its own arguments/parameters. SLA
50 | expects developers to return these arguments via
51 | p_parameters.
52 |
53 +===========================================================================*/
54
55 PROCEDURE DRILLDOWN
56 (p_application_id IN INTEGER
57 ,p_ledger_id IN INTEGER
58 ,p_legal_entity_id IN INTEGER DEFAULT NULL
59 ,p_entity_code IN VARCHAR2
60 ,p_event_class_code IN VARCHAR2
61 ,p_event_type_code IN VARCHAR2
62 ,p_source_id_int_1 IN INTEGER DEFAULT NULL
63 ,p_source_id_int_2 IN INTEGER DEFAULT NULL
64 ,p_source_id_int_3 IN INTEGER DEFAULT NULL
65 ,p_source_id_int_4 IN INTEGER DEFAULT NULL
66 ,p_source_id_char_1 IN VARCHAR2 DEFAULT NULL
67 ,p_source_id_char_2 IN VARCHAR2 DEFAULT NULL
68 ,p_source_id_char_3 IN VARCHAR2 DEFAULT NULL
69 ,p_source_id_char_4 IN VARCHAR2 DEFAULT NULL
70 ,p_security_id_int_1 IN INTEGER DEFAULT NULL
71 ,p_security_id_int_2 IN INTEGER DEFAULT NULL
72 ,p_security_id_int_3 IN INTEGER DEFAULT NULL
73 ,p_security_id_char_1 IN VARCHAR2 DEFAULT NULL
74 ,p_security_id_char_2 IN VARCHAR2 DEFAULT NULL
75 ,p_security_id_char_3 IN VARCHAR2 DEFAULT NULL
76 ,p_valuation_method IN VARCHAR2 DEFAULT NULL
77 ,p_user_interface_type IN OUT NOCOPY VARCHAR2
78 ,p_function_name IN OUT NOCOPY VARCHAR2
79 ,p_parameters IN OUT NOCOPY VARCHAR2)
80
81 IS
82
83 BEGIN
84
85 -- To check whether the application is AP
86 IF (p_application_id =8407) THEN
87
88 IF(p_event_class_code in ('CC_CONTRACT_PRO','CC_CONTRACT_CMT' )) THEN
89 p_user_interface_type := 'FORM';
90 p_function_name := 'XLA_APXINWKB';
91 p_parameters := ' INVOICE_ID="' ||TO_CHAR(p_source_id_int_1) ||'"'
92 ||' ORG_ID="' ||TO_CHAR(p_security_id_int_1) ||'"';
93
94 ELSIF (p_event_class_code = 'CC_REQUISITIONS') THEN
95 p_user_interface_type := 'FORM';
96 p_function_name := 'PO_POXRQVRQ';
97 p_parameters := 'FORM_USAGE_MODE = GL_DRILLDOWN POXDOCON_ACCESS=N TRANSACTION_ID = '||to_char(p_source_id_int_1);
98
99 ELSIF (p_event_class_code = 'CC_REQUISITIONS') THEN
100 p_user_interface_type := 'FORM';
101 p_function_name := 'PO_POXRQVRQ';
102 p_parameters := 'FORM_USAGE_MODE = GL_DRILLDOWN POXDOCON_ACCESS=N TRANSACTION_ID = '||to_char(p_source_id_int_1);
103
104 ELSIF (p_event_class_code = 'CC_PROJECT_BUDGET') THEN
105 p_user_interface_type := 'FORM';
106 p_function_name := 'PA_PAXTRAPE_SINGLE_PROJECT';
107 p_parameters := 'FORM_USAGE_MODE="GL_DRILLDOWN"'
108 ||' TRANSACTION_ID="' || to_char(p_source_id_int_1)||'"'
109 ||' ORG_ID="'||to_char(p_security_id_int_1)||'"';
110 ELSE
111 p_user_interface_type :='NONE';
112 END IF;
113 END IF;
114
115 END DRILLDOWN;
116
117 END IGC_DRILLDOWN_PUB_PKG;