APPS.CN_GET_SRP_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package cn_get_srp_data_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwsfgts.pls 115.7 2002/11/25 22:30:41 nkodkani ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_srp_data_pvt.srp_data_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_300

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_400
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a2 out nocopy JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: );
17: procedure rosetta_table_copy_out_p1(t cn_get_srp_data_pvt.srp_data_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
18: , a1 out nocopy JTF_VARCHAR2_TABLE_400
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE

Line 22: , a5 out nocopy JTF_VARCHAR2_TABLE_100

18: , a1 out nocopy JTF_VARCHAR2_TABLE_400
19: , a2 out nocopy JTF_VARCHAR2_TABLE_100
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_VARCHAR2_TABLE_100
25: , a8 out nocopy JTF_VARCHAR2_TABLE_300
26: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 24: , a7 out nocopy JTF_VARCHAR2_TABLE_100

20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100
23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_VARCHAR2_TABLE_100
25: , a8 out nocopy JTF_VARCHAR2_TABLE_300
26: , a9 out nocopy JTF_VARCHAR2_TABLE_300
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_NUMBER_TABLE

Line 27: , a10 out nocopy JTF_VARCHAR2_TABLE_100

23: , a6 out nocopy JTF_NUMBER_TABLE
24: , a7 out nocopy JTF_VARCHAR2_TABLE_100
25: , a8 out nocopy JTF_VARCHAR2_TABLE_300
26: , a9 out nocopy JTF_VARCHAR2_TABLE_300
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:

Line 29: , a12 out nocopy JTF_VARCHAR2_TABLE_100

25: , a8 out nocopy JTF_VARCHAR2_TABLE_300
26: , a9 out nocopy JTF_VARCHAR2_TABLE_300
27: , a10 out nocopy JTF_VARCHAR2_TABLE_100
28: , a11 out nocopy JTF_NUMBER_TABLE
29: , a12 out nocopy JTF_VARCHAR2_TABLE_100
30: );
31:
32: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
33: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400

Line 34: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100

30: );
31:
32: procedure get_srp_list(p0_a0 out nocopy JTF_NUMBER_TABLE
33: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
34: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , p0_a3 out nocopy JTF_DATE_TABLE
36: , p0_a4 out nocopy JTF_DATE_TABLE
37: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p0_a6 out nocopy JTF_NUMBER_TABLE

Line 37: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100

33: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400
34: , p0_a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , p0_a3 out nocopy JTF_DATE_TABLE
36: , p0_a4 out nocopy JTF_DATE_TABLE
37: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p0_a6 out nocopy JTF_NUMBER_TABLE
39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
41: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100

35: , p0_a3 out nocopy JTF_DATE_TABLE
36: , p0_a4 out nocopy JTF_DATE_TABLE
37: , p0_a5 out nocopy JTF_VARCHAR2_TABLE_100
38: , p0_a6 out nocopy JTF_NUMBER_TABLE
39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
41: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
42: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
43: , p0_a11 out nocopy JTF_NUMBER_TABLE

Line 42: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100

38: , p0_a6 out nocopy JTF_NUMBER_TABLE
39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
41: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
42: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
43: , p0_a11 out nocopy JTF_NUMBER_TABLE
44: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
45: );
46: procedure search_srp_data(p_range_low NUMBER

Line 44: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100

40: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300
41: , p0_a9 out nocopy JTF_VARCHAR2_TABLE_300
42: , p0_a10 out nocopy JTF_VARCHAR2_TABLE_100
43: , p0_a11 out nocopy JTF_NUMBER_TABLE
44: , p0_a12 out nocopy JTF_VARCHAR2_TABLE_100
45: );
46: procedure search_srp_data(p_range_low NUMBER
47: , p_range_high NUMBER
48: , p_date date

Line 58: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

54: , p_order_dir VARCHAR2
55: , x_total_rows out nocopy NUMBER
56: , p10_a0 out nocopy JTF_NUMBER_TABLE
57: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , p10_a3 out nocopy JTF_DATE_TABLE
60: , p10_a4 out nocopy JTF_DATE_TABLE
61: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a6 out nocopy JTF_NUMBER_TABLE

Line 61: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

57: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400
58: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , p10_a3 out nocopy JTF_DATE_TABLE
60: , p10_a4 out nocopy JTF_DATE_TABLE
61: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a6 out nocopy JTF_NUMBER_TABLE
63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

59: , p10_a3 out nocopy JTF_DATE_TABLE
60: , p10_a4 out nocopy JTF_DATE_TABLE
61: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a6 out nocopy JTF_NUMBER_TABLE
63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , p10_a11 out nocopy JTF_NUMBER_TABLE

Line 66: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

62: , p10_a6 out nocopy JTF_NUMBER_TABLE
63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , p10_a11 out nocopy JTF_NUMBER_TABLE
68: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
69: );
70: procedure get_srp_data(p_srp_id NUMBER

Line 68: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

64: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300
65: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
66: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
67: , p10_a11 out nocopy JTF_NUMBER_TABLE
68: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
69: );
70: procedure get_srp_data(p_srp_id NUMBER
71: , p1_a0 out nocopy JTF_NUMBER_TABLE
72: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400

Line 73: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

69: );
70: procedure get_srp_data(p_srp_id NUMBER
71: , p1_a0 out nocopy JTF_NUMBER_TABLE
72: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
73: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
74: , p1_a3 out nocopy JTF_DATE_TABLE
75: , p1_a4 out nocopy JTF_DATE_TABLE
76: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a6 out nocopy JTF_NUMBER_TABLE

Line 76: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100

72: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400
73: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
74: , p1_a3 out nocopy JTF_DATE_TABLE
75: , p1_a4 out nocopy JTF_DATE_TABLE
76: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a6 out nocopy JTF_NUMBER_TABLE
78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
80: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

74: , p1_a3 out nocopy JTF_DATE_TABLE
75: , p1_a4 out nocopy JTF_DATE_TABLE
76: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a6 out nocopy JTF_NUMBER_TABLE
78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
80: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
81: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , p1_a11 out nocopy JTF_NUMBER_TABLE

Line 81: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100

77: , p1_a6 out nocopy JTF_NUMBER_TABLE
78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
80: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
81: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , p1_a11 out nocopy JTF_NUMBER_TABLE
83: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure get_managers(p_srp_id NUMBER

Line 83: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100

79: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300
80: , p1_a9 out nocopy JTF_VARCHAR2_TABLE_300
81: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_100
82: , p1_a11 out nocopy JTF_NUMBER_TABLE
83: , p1_a12 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85: procedure get_managers(p_srp_id NUMBER
86: , p_date date
87: , p_comp_group_id NUMBER

Line 90: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

86: , p_date date
87: , p_comp_group_id NUMBER
88: , p3_a0 out nocopy JTF_NUMBER_TABLE
89: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
90: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , p3_a3 out nocopy JTF_DATE_TABLE
92: , p3_a4 out nocopy JTF_DATE_TABLE
93: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 93: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100

89: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400
90: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
91: , p3_a3 out nocopy JTF_DATE_TABLE
92: , p3_a4 out nocopy JTF_DATE_TABLE
93: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , p3_a6 out nocopy JTF_NUMBER_TABLE
95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
96: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
97: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

91: , p3_a3 out nocopy JTF_DATE_TABLE
92: , p3_a4 out nocopy JTF_DATE_TABLE
93: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , p3_a6 out nocopy JTF_NUMBER_TABLE
95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
96: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
97: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
98: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 98: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100

94: , p3_a6 out nocopy JTF_NUMBER_TABLE
95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
96: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
97: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
98: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , p3_a11 out nocopy JTF_NUMBER_TABLE
100: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
101: );
102: end cn_get_srp_data_pvt_w;

Line 100: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

96: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300
97: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_300
98: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
99: , p3_a11 out nocopy JTF_NUMBER_TABLE
100: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
101: );
102: end cn_get_srp_data_pvt_w;