[Home] [Help]
PACKAGE: APPS.CN_GET_COMM_SUMM_DATA_W
Source
1 package cn_get_comm_summ_data_w AUTHID CURRENT_USER as
2 /* $Header: cnwcomms.pls 115.3 2001/01/15 18:45:58 pkm ship $ */
3 procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_300
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
16 , a1 out JTF_VARCHAR2_TABLE_300
17 , a2 out JTF_VARCHAR2_TABLE_100
18 , a3 out JTF_VARCHAR2_TABLE_100
19 , a4 out JTF_VARCHAR2_TABLE_100
20 , a5 out JTF_VARCHAR2_TABLE_300
21 , a6 out JTF_VARCHAR2_TABLE_100
22 , a7 out JTF_VARCHAR2_TABLE_100
23 , a8 out JTF_NUMBER_TABLE
24 , a9 out JTF_NUMBER_TABLE
25 , a10 out JTF_NUMBER_TABLE
26 );
27
28 procedure rosetta_table_copy_in_p3(t out cn_get_comm_summ_data.pe_info_tbl_type, a0 JTF_VARCHAR2_TABLE_100
29 , a1 JTF_NUMBER_TABLE
30 , a2 JTF_NUMBER_TABLE
31 , a3 JTF_NUMBER_TABLE
32 , a4 JTF_NUMBER_TABLE
33 , a5 JTF_NUMBER_TABLE
34 );
35 procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data.pe_info_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
36 , a1 out JTF_NUMBER_TABLE
37 , a2 out JTF_NUMBER_TABLE
38 , a3 out JTF_NUMBER_TABLE
39 , a4 out JTF_NUMBER_TABLE
40 , a5 out JTF_NUMBER_TABLE
41 );
42
43 procedure get_quota_summary(p_first NUMBER
44 , p_last NUMBER
45 , p_period_id NUMBER
46 , p_user_id NUMBER
47 , p_credit_type_id NUMBER
48 , x_total_rows out NUMBER
49 , p6_a0 out JTF_NUMBER_TABLE
50 , p6_a1 out JTF_VARCHAR2_TABLE_300
51 , p6_a2 out JTF_VARCHAR2_TABLE_100
52 , p6_a3 out JTF_VARCHAR2_TABLE_100
53 , p6_a4 out JTF_VARCHAR2_TABLE_100
54 , p6_a5 out JTF_VARCHAR2_TABLE_300
55 , p6_a6 out JTF_VARCHAR2_TABLE_100
56 , p6_a7 out JTF_VARCHAR2_TABLE_100
57 , p6_a8 out JTF_NUMBER_TABLE
58 , p6_a9 out JTF_NUMBER_TABLE
59 , p6_a10 out JTF_NUMBER_TABLE
60 );
61 procedure get_pe_info(p_srp_plan_assign_id NUMBER
62 , p_period_id NUMBER
63 , p_credit_type_id NUMBER
64 , p3_a0 out JTF_VARCHAR2_TABLE_100
65 , p3_a1 out JTF_NUMBER_TABLE
66 , p3_a2 out JTF_NUMBER_TABLE
67 , p3_a3 out JTF_NUMBER_TABLE
68 , p3_a4 out JTF_NUMBER_TABLE
69 , p3_a5 out JTF_NUMBER_TABLE
70 , p4_a0 out JTF_VARCHAR2_TABLE_100
71 , p4_a1 out JTF_NUMBER_TABLE
72 , p4_a2 out JTF_NUMBER_TABLE
73 , p4_a3 out JTF_NUMBER_TABLE
74 , p4_a4 out JTF_NUMBER_TABLE
75 , p4_a5 out JTF_NUMBER_TABLE
76 , x_ytd_total_earnings out NUMBER
77 , x_ptd_total_earnings out NUMBER
78 );
79 procedure get_group_codes(p0_a0 out JTF_VARCHAR2_TABLE_100
80 , p0_a1 out JTF_NUMBER_TABLE
81 , p0_a2 out JTF_NUMBER_TABLE
82 , p0_a3 out JTF_NUMBER_TABLE
83 , p0_a4 out JTF_NUMBER_TABLE
84 , p0_a5 out JTF_NUMBER_TABLE
85 );
86 end cn_get_comm_summ_data_w;