APPS.ISC_EDW_O2C_DRILL_P dependencies on ICX_SEC

Line 9: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

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: );

Line 10: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 11: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 16: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 17: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 18: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 23: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 24: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 25: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 30: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 31: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 32: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 37: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 38: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 39: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 44: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 45: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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;

Line 46: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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;

Line 57: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_ID),

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: );

Line 58: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 59: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 64: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 65: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 66: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 71: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 72: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 73: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 78: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 79: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 80: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 85: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 86: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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

Line 87: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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',

Line 92: pUserId => icx_sec.getID(icx_sec.PV_WEB_USER_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: );

Line 93: pSessionId => icx_sec.getID(icx_sec.PV_SESSION_ID),

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;

Line 94: pRespId => icx_sec.getId(icx_sec.PV_RESPONSIBILITY_ID),

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;