DBA Data[Home] [Help]

APPS.CN_GET_SRP_DATA_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

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
10: , a7 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_DATE_TABLE

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
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300

Line 20: , a3 out nocopy JTF_DATE_TABLE

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
24: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 21: , a4 out nocopy JTF_DATE_TABLE

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
24: , a7 out nocopy JTF_VARCHAR2_TABLE_100
25: , a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 35: , p0_a3 out nocopy JTF_DATE_TABLE

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
39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , p0_a4 out nocopy JTF_DATE_TABLE

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
39: , p0_a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , p0_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 59: , p10_a3 out nocopy JTF_DATE_TABLE

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
63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , p10_a4 out nocopy JTF_DATE_TABLE

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
63: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
64: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 74: , p1_a3 out nocopy JTF_DATE_TABLE

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
78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , p1_a4 out nocopy JTF_DATE_TABLE

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
78: , p1_a7 out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 91: , p3_a3 out nocopy JTF_DATE_TABLE

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
95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , p3_a4 out nocopy JTF_DATE_TABLE

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
95: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
96: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_300