APPS.CN_GET_SRP_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_400

Line 4: , a1 JTF_VARCHAR2_TABLE_400

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

Line 18: , a1 out nocopy JTF_VARCHAR2_TABLE_400

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
20: , a3 out nocopy JTF_DATE_TABLE
21: , a4 out nocopy JTF_DATE_TABLE
22: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: , p0_a1 out nocopy JTF_VARCHAR2_TABLE_400

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

Line 57: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_400

53: , p_order_by NUMBER
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

Line 72: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_400

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

Line 89: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_400

85: procedure get_managers(p_srp_id NUMBER
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