eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.CN_GET_COMM_SUMM_DATA_PVT_W

Source


1 package cn_get_comm_summ_data_pvt_w as
2   /* $Header: cnwcomms.pls 120.4 2005/10/24 07:21 sjustina noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     );
12   procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13     , a1 out nocopy JTF_VARCHAR2_TABLE_100
14     , a2 out nocopy JTF_VARCHAR2_TABLE_100
15     , a3 out nocopy JTF_DATE_TABLE
16     , a4 out nocopy JTF_DATE_TABLE
17     , a5 out nocopy JTF_NUMBER_TABLE
18     , a6 out nocopy JTF_NUMBER_TABLE
19     , a7 out nocopy JTF_NUMBER_TABLE
20     );
21 
22   procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE);
23   procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
24 
25   procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100);
26   procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
27 
28   procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
29     , a1 JTF_VARCHAR2_TABLE_100
30     , a2 JTF_NUMBER_TABLE
31     , a3 JTF_NUMBER_TABLE
32     , a4 JTF_NUMBER_TABLE
33     , a5 JTF_NUMBER_TABLE
34     , a6 JTF_NUMBER_TABLE
35     , a7 JTF_NUMBER_TABLE
36     , a8 JTF_NUMBER_TABLE
37     , a9 JTF_NUMBER_TABLE
38     , a10 JTF_NUMBER_TABLE
39     , a11 JTF_NUMBER_TABLE
40     );
41   procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
42     , a1 out nocopy JTF_VARCHAR2_TABLE_100
43     , a2 out nocopy JTF_NUMBER_TABLE
44     , a3 out nocopy JTF_NUMBER_TABLE
45     , a4 out nocopy JTF_NUMBER_TABLE
46     , a5 out nocopy JTF_NUMBER_TABLE
47     , a6 out nocopy JTF_NUMBER_TABLE
48     , a7 out nocopy JTF_NUMBER_TABLE
49     , a8 out nocopy JTF_NUMBER_TABLE
50     , a9 out nocopy JTF_NUMBER_TABLE
51     , a10 out nocopy JTF_NUMBER_TABLE
52     , a11 out nocopy JTF_NUMBER_TABLE
53     );
54 
55   procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
56     , a1 JTF_VARCHAR2_TABLE_100
57     , a2 JTF_VARCHAR2_TABLE_100
58     , a3 JTF_VARCHAR2_TABLE_100
59     , a4 JTF_VARCHAR2_TABLE_100
60     , a5 JTF_NUMBER_TABLE
61     );
62   procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
63     , a1 out nocopy JTF_VARCHAR2_TABLE_100
64     , a2 out nocopy JTF_VARCHAR2_TABLE_100
65     , a3 out nocopy JTF_VARCHAR2_TABLE_100
66     , a4 out nocopy JTF_VARCHAR2_TABLE_100
67     , a5 out nocopy JTF_NUMBER_TABLE
68     );
69 
70   procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
71     , a1 JTF_NUMBER_TABLE
72     );
73   procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74     , a1 out nocopy JTF_NUMBER_TABLE
75     );
76 
77   procedure get_salesrep_list(p_first  NUMBER
78     , p_last  NUMBER
79     , p_period_id  NUMBER
80     , p_analyst_id  NUMBER
81     , p_org_id  NUMBER
82     , x_total_rows out nocopy  NUMBER
83     , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE
84   );
85   procedure get_quota_summary(p_salesrep_id  NUMBER
86     , p_period_id  NUMBER
87     , p_credit_type_id  NUMBER
88     , p_org_id  NUMBER
89     , p4_a0 out nocopy JTF_NUMBER_TABLE
90     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
91     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
92     , p4_a3 out nocopy JTF_DATE_TABLE
93     , p4_a4 out nocopy JTF_DATE_TABLE
94     , p4_a5 out nocopy JTF_NUMBER_TABLE
95     , p4_a6 out nocopy JTF_NUMBER_TABLE
96     , p4_a7 out nocopy JTF_NUMBER_TABLE
97   );
98   procedure get_quota_manager_summary(p_period_id  NUMBER
99     , p_credit_type_id  NUMBER
100     , p_org_id  NUMBER
101     , p3_a0 out nocopy JTF_NUMBER_TABLE
102     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
103     , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
104     , p3_a3 out nocopy JTF_DATE_TABLE
105     , p3_a4 out nocopy JTF_DATE_TABLE
106     , p3_a5 out nocopy JTF_NUMBER_TABLE
107     , p3_a6 out nocopy JTF_NUMBER_TABLE
108     , p3_a7 out nocopy JTF_NUMBER_TABLE
109   );
110   procedure get_quota_analyst_summary(p_period_id  NUMBER
111     , p_credit_type_id  NUMBER
112     , p_org_id  NUMBER
113     , p_analyst_id  NUMBER
114     , p4_a0 out nocopy JTF_NUMBER_TABLE
115     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
116     , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
117     , p4_a3 out nocopy JTF_DATE_TABLE
118     , p4_a4 out nocopy JTF_DATE_TABLE
119     , p4_a5 out nocopy JTF_NUMBER_TABLE
120     , p4_a6 out nocopy JTF_NUMBER_TABLE
121     , p4_a7 out nocopy JTF_NUMBER_TABLE
122   );
123   procedure get_salesrep_pe_info(p_salesrep_id  NUMBER
124     , p_period_id  NUMBER
125     , p_credit_type_id  NUMBER
126     , p_org_id  NUMBER
127     , p4_a0 out nocopy JTF_NUMBER_TABLE
128     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
129     , p4_a2 out nocopy JTF_NUMBER_TABLE
130     , p4_a3 out nocopy JTF_NUMBER_TABLE
131     , p4_a4 out nocopy JTF_NUMBER_TABLE
132     , p4_a5 out nocopy JTF_NUMBER_TABLE
133     , p4_a6 out nocopy JTF_NUMBER_TABLE
134     , p4_a7 out nocopy JTF_NUMBER_TABLE
135     , p4_a8 out nocopy JTF_NUMBER_TABLE
136     , p4_a9 out nocopy JTF_NUMBER_TABLE
137     , p4_a10 out nocopy JTF_NUMBER_TABLE
138     , p4_a11 out nocopy JTF_NUMBER_TABLE
139   );
140   procedure get_manager_pe_info(p_period_id  NUMBER
141     , p_credit_type_id  NUMBER
142     , p_org_id  NUMBER
143     , p3_a0 out nocopy JTF_NUMBER_TABLE
144     , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
145     , p3_a2 out nocopy JTF_NUMBER_TABLE
146     , p3_a3 out nocopy JTF_NUMBER_TABLE
147     , p3_a4 out nocopy JTF_NUMBER_TABLE
148     , p3_a5 out nocopy JTF_NUMBER_TABLE
149     , p3_a6 out nocopy JTF_NUMBER_TABLE
150     , p3_a7 out nocopy JTF_NUMBER_TABLE
151     , p3_a8 out nocopy JTF_NUMBER_TABLE
152     , p3_a9 out nocopy JTF_NUMBER_TABLE
153     , p3_a10 out nocopy JTF_NUMBER_TABLE
154     , p3_a11 out nocopy JTF_NUMBER_TABLE
155   );
156   procedure get_analyst_pe_info(p_period_id  NUMBER
157     , p_credit_type_id  NUMBER
158     , p_org_id  NUMBER
159     , p_analyst_id  NUMBER
160     , p4_a0 out nocopy JTF_NUMBER_TABLE
161     , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
162     , p4_a2 out nocopy JTF_NUMBER_TABLE
163     , p4_a3 out nocopy JTF_NUMBER_TABLE
164     , p4_a4 out nocopy JTF_NUMBER_TABLE
165     , p4_a5 out nocopy JTF_NUMBER_TABLE
166     , p4_a6 out nocopy JTF_NUMBER_TABLE
167     , p4_a7 out nocopy JTF_NUMBER_TABLE
168     , p4_a8 out nocopy JTF_NUMBER_TABLE
169     , p4_a9 out nocopy JTF_NUMBER_TABLE
170     , p4_a10 out nocopy JTF_NUMBER_TABLE
171     , p4_a11 out nocopy JTF_NUMBER_TABLE
172   );
173   procedure get_salesrep_details(p_salesrep_id  NUMBER
174     , p_org_id  NUMBER
175     , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
176     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
177     , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
178     , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
179     , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
180     , p2_a5 out nocopy JTF_NUMBER_TABLE
181   );
182   procedure get_manager_details(p_org_id  NUMBER
183     , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
184     , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
185     , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
186     , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
187     , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
188     , p1_a5 out nocopy JTF_NUMBER_TABLE
189   );
190   procedure get_analyst_details(p_org_id  NUMBER
191     , p_analyst_id  NUMBER
192     , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
193     , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
194     , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
195     , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
196     , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
197     , p2_a5 out nocopy JTF_NUMBER_TABLE
198   );
199   procedure get_group_codes(p_org_id  NUMBER
200     , x_result_tbl out nocopy JTF_VARCHAR2_TABLE_100
201   );
202   procedure get_ptd_credit(p_salesrep_id  NUMBER
203     , p_payrun_id  NUMBER
204     , p_org_id  NUMBER
205     , p3_a0 in out nocopy JTF_NUMBER_TABLE
206     , p3_a1 in out nocopy JTF_NUMBER_TABLE
207   );
208 end cn_get_comm_summ_data_pvt_w;