[Home] [Help]
PACKAGE: APPS.CN_GET_SRP_DATA_PVT_W
Source
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
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
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
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
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
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
49 , p_search_name VARCHAR2
50 , p_search_job VARCHAR2
51 , p_search_emp_num VARCHAR2
52 , p_search_group VARCHAR2
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
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
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
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
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
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;