eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.ISC_EDW_O2C_DRILL_P

Source


1 PACKAGE BODY isc_edw_o2c_drill_p AS
2 /* $Header: ISCO2CDB.pls 115.8 2002/12/13 21:11:45 kxliu ship $ */
3 
4 PROCEDURE drill_across_wk (pParameter1 IN NUMBER)
5 IS
6 BEGIN
7    IF pParameter1 = 1 THEN
8       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_TOP_ORDERS_WK',
9                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
10                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
11                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
12                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
13                                            );
14     ELSIF pParameter1 = 2 THEN
15      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_WK&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
16                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
17                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
18                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
19                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
20                                           );
21     ELSIF pParameter1 = 3 THEN
22      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_WK&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
23                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
24                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
25                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
26                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
27                                           );
28    ELSIF pParameter1 = 4 THEN
29      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_INV_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
30                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
31                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
32                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
33                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
34                                           );
35    ELSIF pParameter1 = 5 THEN
36       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_REV_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
37                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
38                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
39                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
40                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
41                                            );
42    ELSIF pParameter1 = 6 THEN
43       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_CASH_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
44                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
45                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
46                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
47                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
48                                            );
49    END IF;
50 END drill_across_wk;
51 
52 PROCEDURE drill_across_qtd (pParameter1 IN NUMBER)
53 IS
54 BEGIN
55    IF pParameter1 = 1 THEN
56       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_TOP_ORDERS_QTD',
57                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
58                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
59                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
60                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
61                                            );
62    ELSIF pParameter1 = 2 THEN
63      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_QTD&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
64                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
65                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
66                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
67                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
68                                           );
69     ELSIF pParameter1 = 3 THEN
70      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_QTD&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
71                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
72                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
73                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
74                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
75                                           );
76    ELSIF pParameter1 = 4 THEN
77      bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_INV_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
78                                           pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
79                                           pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
80                                           pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
81                                           pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
82                                           );
83    ELSIF pParameter1 = 5 THEN
84       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_REV_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
85                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
86                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
87                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
88                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
89                                            );
90    ELSIF pParameter1 = 6 THEN
91       bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_CASH_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',
92                                             pUserId  => icx_sec.getID(icx_sec.PV_WEB_USER_ID),
93                                             pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),
94                                             pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),
95                                             pFunctionName=> 'ISC_OPI_IND_CROSS_TAB'
96                                            );
97    END IF;
98 END drill_across_qtd;
99 
100 END isc_edw_o2c_drill_p;