DBA Data[Home] [Help]

APPS.ISC_EDW_O2C_DRILL_P dependencies on BIS_PARAMETER_VALIDATION

Line 8: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_TOP_ORDERS_WK',

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'

Line 15: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_WK&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 22: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_WK&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 29: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_INV_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 36: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_REV_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 43: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_CASH_CUST_L7D&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 56: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_TOP_ORDERS_QTD',

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'

Line 63: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_QTD&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 70: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=ISC_OPI_BOOKED_ORD_SUM_QTD&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 77: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_INV_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 84: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_REV_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'

Line 91: bis_parameter_validation.drillacross(pURLString => 'pFunctionName=FII_AR_CASH_CUST&VIEW_BY=EDW_TRD_PARTNER_M+EDW_TPRT_TRADE_PARTNER',

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'