DBA Data[Home] [Help]

APPS.CN_PLAN_TEXTS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE

1: package cn_plan_texts_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwspts.pls 115.9 2002/12/04 05:04:21 fmburu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package cn_plan_texts_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwspts.pls 115.9 2002/12/04 05:04:21 fmburu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_NUMBER_TABLE

1: package cn_plan_texts_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwspts.pls 115.9 2002/12/04 05:04:21 fmburu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwspts.pls 115.9 2002/12/04 05:04:21 fmburu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 14: , a1 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 15: , a2 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 16: , a3 out nocopy JTF_NUMBER_TABLE

12: );
13: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a7 out nocopy JTF_NUMBER_TABLE

Line 20: , a7 out nocopy JTF_NUMBER_TABLE

16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE

Line 21: , a8 out nocopy JTF_NUMBER_TABLE

17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_VARCHAR2_TABLE_100

Line 24: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE

20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_VARCHAR2_TABLE_100
26: );
27: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 27: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

23:
24: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_VARCHAR2_TABLE_100
26: );
27: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_VARCHAR2_TABLE_100
29: );
30:
31: procedure create_plan_text(p_api_version NUMBER

Line 88: , p6_a0 out nocopy JTF_NUMBER_TABLE

84: , p_commit VARCHAR2
85: , p_validation_level NUMBER
86: , p_role_id NUMBER
87: , p_role_model_id NUMBER
88: , p6_a0 out nocopy JTF_NUMBER_TABLE
89: , p6_a1 out nocopy JTF_NUMBER_TABLE
90: , p6_a2 out nocopy JTF_NUMBER_TABLE
91: , p6_a3 out nocopy JTF_NUMBER_TABLE
92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , p6_a1 out nocopy JTF_NUMBER_TABLE

85: , p_validation_level NUMBER
86: , p_role_id NUMBER
87: , p_role_model_id NUMBER
88: , p6_a0 out nocopy JTF_NUMBER_TABLE
89: , p6_a1 out nocopy JTF_NUMBER_TABLE
90: , p6_a2 out nocopy JTF_NUMBER_TABLE
91: , p6_a3 out nocopy JTF_NUMBER_TABLE
92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 90: , p6_a2 out nocopy JTF_NUMBER_TABLE

86: , p_role_id NUMBER
87: , p_role_model_id NUMBER
88: , p6_a0 out nocopy JTF_NUMBER_TABLE
89: , p6_a1 out nocopy JTF_NUMBER_TABLE
90: , p6_a2 out nocopy JTF_NUMBER_TABLE
91: , p6_a3 out nocopy JTF_NUMBER_TABLE
92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
94: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 91: , p6_a3 out nocopy JTF_NUMBER_TABLE

87: , p_role_model_id NUMBER
88: , p6_a0 out nocopy JTF_NUMBER_TABLE
89: , p6_a1 out nocopy JTF_NUMBER_TABLE
90: , p6_a2 out nocopy JTF_NUMBER_TABLE
91: , p6_a3 out nocopy JTF_NUMBER_TABLE
92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
94: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
95: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 95: , p6_a7 out nocopy JTF_NUMBER_TABLE

91: , p6_a3 out nocopy JTF_NUMBER_TABLE
92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
94: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
95: , p6_a7 out nocopy JTF_NUMBER_TABLE
96: , p6_a8 out nocopy JTF_NUMBER_TABLE
97: , x_updatable out nocopy VARCHAR2
98: , x_return_status out nocopy VARCHAR2
99: , x_msg_count out nocopy NUMBER

Line 96: , p6_a8 out nocopy JTF_NUMBER_TABLE

92: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
93: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
94: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
95: , p6_a7 out nocopy JTF_NUMBER_TABLE
96: , p6_a8 out nocopy JTF_NUMBER_TABLE
97: , x_updatable out nocopy VARCHAR2
98: , x_return_status out nocopy VARCHAR2
99: , x_msg_count out nocopy NUMBER
100: , x_msg_data out nocopy VARCHAR2

Line 108: , p6_a0 out nocopy JTF_NUMBER_TABLE

104: , p_commit VARCHAR2
105: , p_validation_level NUMBER
106: , p_role_id NUMBER
107: , p_role_model_id NUMBER
108: , p6_a0 out nocopy JTF_NUMBER_TABLE
109: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
110: , x_return_status out nocopy VARCHAR2
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2

Line 120: , p6_a0 out nocopy JTF_NUMBER_TABLE

116: , p_commit VARCHAR2
117: , p_validation_level NUMBER
118: , p_role_id NUMBER
119: , p_role_model_id NUMBER
120: , p6_a0 out nocopy JTF_NUMBER_TABLE
121: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
122: , x_return_status out nocopy VARCHAR2
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2

Line 133: , p7_a0 out nocopy JTF_NUMBER_TABLE

129: , p_validation_level NUMBER
130: , p_role_id NUMBER
131: , p_role_model_id NUMBER
132: , p_quota_cate_type VARCHAR2
133: , p7_a0 out nocopy JTF_NUMBER_TABLE
134: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , x_return_status out nocopy VARCHAR2
136: , x_msg_count out nocopy NUMBER
137: , x_msg_data out nocopy VARCHAR2