DBA Data[Home] [Help]

APPS.CN_PLAN_ELEMENT_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package cn_plan_element_pvt_w as
2: /* $Header: cnwpes.pls 120.2.12000000.2 2007/10/08 18:56:21 rnagired ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_element_pvt.plan_element_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_1900
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: cnwpes.pls 120.2.12000000.2 2007/10/08 18:56:21 rnagired ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_element_pvt.plan_element_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_1900
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_4000
19: , a16 JTF_VARCHAR2_TABLE_4000
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_200

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_4000
19: , a16 JTF_VARCHAR2_TABLE_4000
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_VARCHAR2_TABLE_200

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_VARCHAR2_TABLE_4000
19: , a16 JTF_VARCHAR2_TABLE_4000
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_200

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_4000
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_200
36: , a33 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_VARCHAR2_TABLE_200
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_VARCHAR2_TABLE_200
37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_VARCHAR2_TABLE_200
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_VARCHAR2_TABLE_200
38: , a35 JTF_VARCHAR2_TABLE_200
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );

Line 45: , a42 JTF_VARCHAR2_TABLE_100

41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t cn_plan_element_pvt.plan_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t cn_plan_element_pvt.plan_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a44 JTF_VARCHAR2_TABLE_100

43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t cn_plan_element_pvt.plan_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_1900

Line 50: , a1 out nocopy JTF_VARCHAR2_TABLE_100

46: , a43 JTF_VARCHAR2_TABLE_100
47: , a44 JTF_VARCHAR2_TABLE_100
48: );
49: procedure rosetta_table_copy_out_p1(t cn_plan_element_pvt.plan_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_1900
52: , a3 out nocopy JTF_VARCHAR2_TABLE_100
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_NUMBER_TABLE

Line 52: , a3 out nocopy JTF_VARCHAR2_TABLE_100

48: );
49: procedure rosetta_table_copy_out_p1(t cn_plan_element_pvt.plan_element_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_100
51: , a2 out nocopy JTF_VARCHAR2_TABLE_1900
52: , a3 out nocopy JTF_VARCHAR2_TABLE_100
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_NUMBER_TABLE
55: , a6 out nocopy JTF_NUMBER_TABLE
56: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , a7 out nocopy JTF_VARCHAR2_TABLE_100

52: , a3 out nocopy JTF_VARCHAR2_TABLE_100
53: , a4 out nocopy JTF_NUMBER_TABLE
54: , a5 out nocopy JTF_NUMBER_TABLE
55: , a6 out nocopy JTF_NUMBER_TABLE
56: , a7 out nocopy JTF_VARCHAR2_TABLE_100
57: , a8 out nocopy JTF_DATE_TABLE
58: , a9 out nocopy JTF_DATE_TABLE
59: , a10 out nocopy JTF_NUMBER_TABLE
60: , a11 out nocopy JTF_NUMBER_TABLE

Line 66: , a17 out nocopy JTF_VARCHAR2_TABLE_100

62: , a13 out nocopy JTF_NUMBER_TABLE
63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_VARCHAR2_TABLE_4000
65: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
66: , a17 out nocopy JTF_VARCHAR2_TABLE_100
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 67: , a18 out nocopy JTF_VARCHAR2_TABLE_100

63: , a14 out nocopy JTF_NUMBER_TABLE
64: , a15 out nocopy JTF_VARCHAR2_TABLE_4000
65: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
66: , a17 out nocopy JTF_VARCHAR2_TABLE_100
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_200
71: , a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 68: , a19 out nocopy JTF_VARCHAR2_TABLE_100

64: , a15 out nocopy JTF_VARCHAR2_TABLE_4000
65: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
66: , a17 out nocopy JTF_VARCHAR2_TABLE_100
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_200
71: , a22 out nocopy JTF_VARCHAR2_TABLE_200
72: , a23 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a20 out nocopy JTF_VARCHAR2_TABLE_100

65: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
66: , a17 out nocopy JTF_VARCHAR2_TABLE_100
67: , a18 out nocopy JTF_VARCHAR2_TABLE_100
68: , a19 out nocopy JTF_VARCHAR2_TABLE_100
69: , a20 out nocopy JTF_VARCHAR2_TABLE_100
70: , a21 out nocopy JTF_VARCHAR2_TABLE_200
71: , a22 out nocopy JTF_VARCHAR2_TABLE_200
72: , a23 out nocopy JTF_VARCHAR2_TABLE_200
73: , a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 85: , a36 out nocopy JTF_VARCHAR2_TABLE_100

81: , a32 out nocopy JTF_VARCHAR2_TABLE_200
82: , a33 out nocopy JTF_VARCHAR2_TABLE_200
83: , a34 out nocopy JTF_VARCHAR2_TABLE_200
84: , a35 out nocopy JTF_VARCHAR2_TABLE_200
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE

Line 86: , a37 out nocopy JTF_VARCHAR2_TABLE_100

82: , a33 out nocopy JTF_VARCHAR2_TABLE_200
83: , a34 out nocopy JTF_VARCHAR2_TABLE_200
84: , a35 out nocopy JTF_VARCHAR2_TABLE_200
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , a38 out nocopy JTF_VARCHAR2_TABLE_100

83: , a34 out nocopy JTF_VARCHAR2_TABLE_200
84: , a35 out nocopy JTF_VARCHAR2_TABLE_200
85: , a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , a41 out nocopy JTF_VARCHAR2_TABLE_100

86: , a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_VARCHAR2_TABLE_100
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );

Line 91: , a42 out nocopy JTF_VARCHAR2_TABLE_100

87: , a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_VARCHAR2_TABLE_100
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:

Line 92: , a43 out nocopy JTF_VARCHAR2_TABLE_100

88: , a39 out nocopy JTF_NUMBER_TABLE
89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_VARCHAR2_TABLE_100
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure is_valid_org(p_org_id NUMBER

Line 93: , a44 out nocopy JTF_VARCHAR2_TABLE_100

89: , a40 out nocopy JTF_NUMBER_TABLE
90: , a41 out nocopy JTF_VARCHAR2_TABLE_100
91: , a42 out nocopy JTF_VARCHAR2_TABLE_100
92: , a43 out nocopy JTF_VARCHAR2_TABLE_100
93: , a44 out nocopy JTF_VARCHAR2_TABLE_100
94: );
95:
96: procedure is_valid_org(p_org_id NUMBER
97: , p_quota_id NUMBER