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

Source


1 PACKAGE poa_cm_eval_scores_icx AS
2 /* $Header: POACMSCS.pls 120.0 2005/06/02 00:37:54 appldev noship $ */
3 
4 TYPE t_criteria_record IS RECORD (
5   criteria_code VARCHAR2(25),
6   weight	NUMBER,
7   min_score	NUMBER,
8   max_score	NUMBER
9 );
10 
11 TYPE t_scores_record IS RECORD (
12   score		NUMBER,
13   comments      VARCHAR2(240)
14 );
15 
16 TYPE t_eval_record IS RECORD (
17   eval_id		NUMBER,
18   supplier_site		VARCHAR2(15),
19   oper_unit		VARCHAR2(60),
20   commodity		VARCHAR2(81),
21   item			VARCHAR2(40),
22   evaluator		VARCHAR2(100),
23   creation_date		DATE,
24   last_update_date	DATE
25 );
26 
27 TYPE t_header_record IS RECORD (
28   custom_measure_code 	VARCHAR2(240),
29   custom_measure 	VARCHAR2(240),
30   period_type 		VARCHAR2(240),
31   user_period_type 	VARCHAR2(240),
32   period_name 		VARCHAR2(240),
33   supplier_id 		VARCHAR2(240),
34   supplier 		VARCHAR2(240),
35   supplier_site_id 	VARCHAR2(240),
36   supplier_site 	VARCHAR2(240),
37   category_id 		VARCHAR2(240),
38   commodity 		VARCHAR2(240),
39   item_id 		VARCHAR2(240),
40   item 			VARCHAR2(240),
41   comments 		VARCHAR2(240),
42   evaluated_by_id 	VARCHAR2(240),
43   evaluated_by 		VARCHAR2(240),
44   org_id 		VARCHAR2(240),
45   oper_unit_id 		VARCHAR2(240),
46   operating_unit 	VARCHAR2(240),
47   submit_type	        VARCHAR2(10),
48   evaluation_id		VARCHAR2(10)
49 );
50 
51 TYPE t_criteria_table IS TABLE OF t_criteria_record INDEX BY BINARY_INTEGER;
52 TYPE t_scores_table IS TABLE OF t_scores_record INDEX BY BINARY_INTEGER;
53 
54 PROCEDURE score_entry_page(poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
55 			   poa_cm_custom_measure      IN VARCHAR2 DEFAULT NULL,
56 			   poa_cm_period_type	      IN VARCHAR2 DEFAULT NULL,
57 			   poa_cm_user_period_type    IN VARCHAR2 DEFAULT NULL,
58 			   poa_cm_period_name	      IN VARCHAR2 DEFAULT NULL,
59 			   poa_cm_supplier_id	      IN VARCHAR2 DEFAULT NULL,
60 			   poa_cm_supplier	      IN VARCHAR2 DEFAULT NULL,
61 			   poa_cm_supplier_site_id    IN VARCHAR2 DEFAULT NULL,
62 			   poa_cm_supplier_site       IN VARCHAR2 DEFAULT NULL,
63 			   poa_cm_category_id	      IN VARCHAR2 DEFAULT NULL,
64 			   poa_cm_commodity	      IN VARCHAR2 DEFAULT NULL,
65 			   poa_cm_item_id	      IN VARCHAR2 DEFAULT NULL,
66 			   poa_cm_item		      IN VARCHAR2 DEFAULT NULL,
67 			   poa_cm_comments	      IN VARCHAR2 DEFAULT NULL,
68 			   poa_cm_evaluated_by_id     IN VARCHAR2 DEFAULT NULL,
69 			   poa_cm_evaluated_by	      IN VARCHAR2 DEFAULT NULL,
70 			   poa_cm_org_id	      IN VARCHAR2 DEFAULT NULL,
71 			   poa_cm_oper_unit_id	      IN VARCHAR2 DEFAULT NULL,
72 			   poa_cm_operating_unit      IN VARCHAR2 DEFAULT NULL,
73 			   poa_cm_submit_type 	      IN VARCHAR2 DEFAULT NULL,
74 			   poa_cm_evaluation_id	      IN VARCHAR2 DEFAULT NULL
75 );
76 
77 PROCEDURE  Get_Criteria_Info(  p_category_id	  IN NUMBER,
78 			       p_oper_unit_id	  IN NUMBER,
79 			       p_table		  IN OUT NOCOPY t_criteria_table);
80 
81 PROCEDURE redirect_page(poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
82 			poa_cm_custom_measure      IN VARCHAR2 DEFAULT NULL,
83 			poa_cm_period_type	   IN VARCHAR2 DEFAULT NULL,
84 			poa_cm_user_period_type    IN VARCHAR2 DEFAULT NULL,
85 			poa_cm_period_name	   IN VARCHAR2 DEFAULT NULL,
86 			poa_cm_supplier_id	   IN VARCHAR2 DEFAULT NULL,
87 			poa_cm_supplier	      	   IN VARCHAR2 DEFAULT NULL,
88 			poa_cm_supplier_site_id    IN VARCHAR2 DEFAULT NULL,
89 		 	poa_cm_supplier_site       IN VARCHAR2 DEFAULT NULL,
90 			poa_cm_category_id	   IN VARCHAR2 DEFAULT NULL,
91 			poa_cm_commodity	   IN VARCHAR2 DEFAULT NULL,
92 			poa_cm_item_id		   IN VARCHAR2 DEFAULT NULL,
93 			poa_cm_item		   IN VARCHAR2 DEFAULT NULL,
94 			poa_cm_comments		   IN VARCHAR2 DEFAULT NULL,
95 			poa_cm_evaluated_by_id     IN VARCHAR2 DEFAULT NULL,
96 			poa_cm_evaluated_by	   IN VARCHAR2 DEFAULT NULL,
97 			poa_cm_org_id	      	   IN VARCHAR2 DEFAULT NULL,
98 			poa_cm_oper_unit_id	   IN VARCHAR2 DEFAULT NULL,
99 			poa_cm_operating_unit      IN VARCHAR2 DEFAULT NULL,
100 			poa_cm_submit_type	   IN VARCHAR2 DEFAULT NULL,
101 			poa_cm_evaluation_id	   IN VARCHAR2 DEFAULT NULL
102 );
103 
104 PROCEDURE query_evals(  poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
105 			poa_cm_custom_measure      IN VARCHAR2 DEFAULT NULL,
106 			poa_cm_period_type	   IN VARCHAR2 DEFAULT NULL,
107 			poa_cm_user_period_type    IN VARCHAR2 DEFAULT NULL,
108 			poa_cm_period_name	   IN VARCHAR2 DEFAULT NULL,
109 			poa_cm_supplier_id	   IN VARCHAR2 DEFAULT NULL,
110 			poa_cm_supplier	      	   IN VARCHAR2 DEFAULT NULL,
111 			poa_cm_supplier_site_id    IN VARCHAR2 DEFAULT NULL,
112 		 	poa_cm_supplier_site       IN VARCHAR2 DEFAULT NULL,
113 			poa_cm_category_id	   IN VARCHAR2 DEFAULT NULL,
114 			poa_cm_commodity	   IN VARCHAR2 DEFAULT NULL,
115 			poa_cm_item_id		   IN VARCHAR2 DEFAULT NULL,
116 			poa_cm_item		   IN VARCHAR2 DEFAULT NULL,
117 			poa_cm_comments		   IN VARCHAR2 DEFAULT NULL,
118 			poa_cm_evaluated_by_id     IN VARCHAR2 DEFAULT NULL,
119 			poa_cm_evaluated_by	   IN VARCHAR2 DEFAULT NULL,
120 			poa_cm_org_id	      	   IN VARCHAR2 DEFAULT NULL,
121 			poa_cm_oper_unit_id	   IN VARCHAR2 DEFAULT NULL,
122 			poa_cm_operating_unit      IN VARCHAR2 DEFAULT NULL,
123 			poa_cm_submit_type	   IN VARCHAR2 DEFAULT NULL,
124 			poa_cm_evaluation_id	   IN VARCHAR2 DEFAULT NULL
125 );
126 
127 
128 END poa_cm_eval_scores_icx;