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_WEBSERVICE_PUB

Source


1 PACKAGE CN_WEBSERVICE_PUB AUTHID CURRENT_USER as
2 -- $Header: cnwebsrs.pls 120.1 2009/06/18 07:36:33 ipananil noship $ --+
3 /*#
4  * The procedures in this packages are used for webservice generation
5  * @rep:scope public
6  * @rep:product CN
7  * @rep:displayname Gadget Web Service
8  * @rep:lifecycle active
9  * @rep:compatibility S
10  * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
11  */
12 
13  /**Start of MOAC Org Validation change */
14 l_org_id NUMBER;
15 l_status VARCHAR2(1);
16  /**End of MOAC Org Validation change */
17 
18 TYPE RECENT_TRANSACTION_TYPE is RECORD
19 (PROCESSED_DATE       VARCHAR2(10),
20  CUSTOMER_NAME        VARCHAR2(2000),
21  PRODUCT_NAME	      VARCHAR2(2000),
22  TRANSACTION_AMOUNT   VARCHAR2(2000),
23  CREDIT			      VARCHAR2(2000),
24  EARNINGS             VARCHAR2(2000),
25  CURRENCY_SYMB		  VARCHAR2(2)
26 );
27 
28 TYPE RECENT_TRANSACTION_TBL_TYPE IS TABLE OF RECENT_TRANSACTION_TYPE INDEX BY BINARY_INTEGER ;
29 
30 G_MISS_RT_REC_TB  RECENT_TRANSACTION_TBL_TYPE;
31 
32 /*#
33  * This API is used as webservice for Recent Transaction for salesrep.
34  * @param x_recent_transaction_tbl Recent Transaction Table Type
35  * @param usr_name Login Username
36  * @rep:scope public
37  * @rep:lifecycle active
38  * @rep:displayname Recent Transaction For SalesRep
39  * @rep:compatibility S
40  * @rep:businessevent None
41  */
42  PROCEDURE RECENT_TRANS_FOR_SALESREP
43    (
44 	 usr_name							IN  VARCHAR,
45      x_recent_transaction_tbl 	        OUT NOCOPY RECENT_TRANSACTION_TBL_TYPE
46    );
47 
48 
49 TYPE TOP_CUSTOMER_TYPE is RECORD
50 (CUSTOMER_NAME        VARCHAR2(2000),
51  EARNINGS             VARCHAR2(2000),
52  RATE                 VARCHAR2(2000),
53  CREDIT			      VARCHAR2(2000),
54  TRANSACTION_AMOUNT   VARCHAR2(2000),
55  CURRENCY_SYMB		  VARCHAR2(2)
56 );
57 
58 TYPE TOP_CUSTOMER_TBL_TYPE IS TABLE OF TOP_CUSTOMER_TYPE INDEX BY BINARY_INTEGER ;
59 
60 G_MISS_CT_REC_TB  TOP_CUSTOMER_TBL_TYPE;
61 
62 /*#
63  * This API is used as webservice for Top Customer for salesrep.
64  * @param x_top_customer_tbl Customer Transaction Table Type
65  * @param usr_name Login Username
66  * @rep:scope public
67  * @rep:lifecycle active
68  * @rep:displayname Top Customer For SalesRep
69  * @rep:compatibility S
70  * @rep:businessevent None
71  */
72  PROCEDURE TOP_CUSTOMER_FOR_SALESREP
73    (
74      usr_name						IN VARCHAR,
75      x_top_customer_tbl 	        OUT NOCOPY TOP_CUSTOMER_TBL_TYPE
76    );
77 
78 TYPE TOP_CUST_PROD_TYPE is RECORD
79 (PRODUCT_NAME         VARCHAR2(2000),
80  EARNINGS             VARCHAR2(2000),
81  RATE                 VARCHAR2(2000),
82  CREDIT			      VARCHAR2(2000),
83  TRANSACTION_AMOUNT   VARCHAR2(2000),
84  CURRENCY_SYMB		  VARCHAR2(2)
85 );
86 
87 TYPE TOP_CUS_PROD_TBL_TYPE IS TABLE OF TOP_CUST_PROD_TYPE INDEX BY BINARY_INTEGER ;
88 
89 G_MISS_CT_PROD_REC_TB  TOP_CUS_PROD_TBL_TYPE;
90 
91 /*#
92  * This API is used as webservice for Top product for salesrep.
93  * @param x_top_cust_prod_tbl Top Product Table Type
94  * @param usr_name Login Username
95  * @rep:scope public
96  * @rep:lifecycle active
97  * @rep:displayname Top product For SalesRep
98  * @rep:compatibility S
99  * @rep:businessevent None
100  */
101  PROCEDURE TOP_PRODUCT_FOR_SALESREP
102    (
103      usr_name						IN VARCHAR,
104      x_top_cust_prod_tbl 	        OUT NOCOPY TOP_CUS_PROD_TBL_TYPE
105    );
106 
107 
108 TYPE TOP_ESC_TASK_TYPE is RECORD
109 (TASK_NUMBER             VARCHAR2(2000),
110  TASK_ID				 NUMBER,
111  ASSIGNMENT_STATUS		 VARCHAR2(1000),
112  TASK_NAME    		     VARCHAR2(2000),
113  CUSTOMER_NAME			 VARCHAR2(2000),
114  PRIORITY_NAME			 VARCHAR2(500),
115  RESOURCE_NAME			 VARCHAR2(1000),
116  RESOURCE_ID 			 NUMBER,
117  RESOURCE_TYPE_CODE		 VARCHAR2(255),
118  PLANNED_START_DATE		 DATE,
119  SCHEDULED_START_DATE    DATE,
120  SLA_ESC				 VARCHAR2(5),
121  CALC_DATE				 NUMBER
122 );
123 
124 TYPE TOP_ESC_TASK_TBL_TYPE IS TABLE OF TOP_ESC_TASK_TYPE INDEX BY BINARY_INTEGER ;
125 
126 G_MISS_EC_TASK_REC_TB  TOP_ESC_TASK_TBL_TYPE;
127 
128 /*#
129  * This API is used as webservice for Top Escalted Tasks for salesrep.
130  * @param x_top_esc_task_tbl Top Escalated Table Type
131  * @param usr_name Login Username
132  * @rep:scope public
133  * @rep:lifecycle active
134  * @rep:displayname Top Escalated Task for Resource
135  * @rep:compatibility S
136  * @rep:businessevent None
137  */
138  PROCEDURE TOP_ESCALTED_TASK_SALESREP
139    (
140      usr_name						IN VARCHAR,
141      x_top_esc_task_tbl 	        OUT NOCOPY TOP_ESC_TASK_TBL_TYPE
142    );
143 
144 
145 TYPE test_webser_rec_type is RECORD
146 (commission CN_COMMISSION_LINES.COMMISSION_AMOUNT%TYPE,
147  userid		VARCHAR(1000)
148 );
149 
150 TYPE test_webser_tbl_type IS TABLE OF test_webser_rec_type INDEX BY BINARY_INTEGER ;
151 
152 G_MISS_WEBSER_REC_TB  test_webser_tbl_type;
153 
154 
155 /*#
156  * This API is used to test webservice pay groups.
157  * @param x_commission_rec Commission earned
158  * @param user_id Salesrep_id
159  * @rep:scope public
160  * @rep:lifecycle active
161  * @rep:displayname Test Webservice
162  * @rep:compatibility S
163  * @rep:businessevent None
164  */
165  PROCEDURE  Test_Webservice
166    ( user_id					IN  VARCHAR2,
167      x_commission_rec 	        OUT NOCOPY test_webser_tbl_type
168     );
169 
170 
171 
172 END CN_WEBSERVICE_PUB ;