[Home] [Help]
PACKAGE: APPS.POA_CM_ENTER_SCORES_ICX
Source
1 PACKAGE poa_cm_enter_scores_icx AS
2 /* $Header: POACMINS.pls 120.0 2005/06/01 20:00:53 appldev noship $ */
3
4 TYPE t_text_table is table of varchar2(240) index by binary_integer;
5
6 PROCEDURE insert_scores(criteria_code IN t_text_table,
7 score IN t_text_table,
8 weight IN t_text_table,
9 weighted_score IN t_text_table,
10 min_score IN t_text_table,
11 max_score IN t_text_table,
12 comments IN t_text_table,
13 total_score IN VARCHAR2,
14 poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
15 poa_cm_custom_measure IN VARCHAR2 DEFAULT NULL,
16 poa_cm_period_type IN VARCHAR2 DEFAULT NULL,
17 poa_cm_user_period_type IN VARCHAR2 DEFAULT NULL,
18 poa_cm_period_name IN VARCHAR2 DEFAULT NULL,
19 poa_cm_supplier_id IN VARCHAR2 DEFAULT NULL,
20 poa_cm_supplier IN VARCHAR2 DEFAULT NULL,
21 poa_cm_supplier_site_id IN VARCHAR2 DEFAULT NULL,
22 poa_cm_supplier_site IN VARCHAR2 DEFAULT NULL,
23 poa_cm_category_id IN VARCHAR2 DEFAULT NULL,
24 poa_cm_commodity IN VARCHAR2 DEFAULT NULL,
25 poa_cm_item_id IN VARCHAR2 DEFAULT NULL,
26 poa_cm_item IN VARCHAR2 DEFAULT NULL,
27 poa_cm_comments IN VARCHAR2 DEFAULT NULL,
28 poa_cm_evaluated_by_id IN VARCHAR2 DEFAULT NULL,
29 poa_cm_evaluated_by IN VARCHAR2 DEFAULT NULL,
30 poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
31 poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
32 poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
33 poa_cm_submit_type IN VARCHAR2 DEFAULT NULL,
34 poa_cm_evaluation_id IN VARCHAR2 DEFAULT NULL
35 );
36
37 PROCEDURE redirect_page(criteria_code IN t_text_table,
38 score IN t_text_table,
39 weight IN t_text_table,
40 weighted_score IN t_text_table,
41 min_score IN t_text_table,
42 max_score IN t_text_table,
43 comments IN t_text_table,
44 total_score IN VARCHAR2,
45 poa_cm_custom_measure_code IN VARCHAR2 DEFAULT NULL,
46 poa_cm_custom_measure IN VARCHAR2 DEFAULT NULL,
47 poa_cm_period_type IN VARCHAR2 DEFAULT NULL,
48 poa_cm_user_period_type IN VARCHAR2 DEFAULT NULL,
49 poa_cm_period_name IN VARCHAR2 DEFAULT NULL,
50 poa_cm_supplier_id IN VARCHAR2 DEFAULT NULL,
51 poa_cm_supplier IN VARCHAR2 DEFAULT NULL,
52 poa_cm_supplier_site_id IN VARCHAR2 DEFAULT NULL,
53 poa_cm_supplier_site IN VARCHAR2 DEFAULT NULL,
54 poa_cm_category_id IN VARCHAR2 DEFAULT NULL,
55 poa_cm_commodity IN VARCHAR2 DEFAULT NULL,
56 poa_cm_item_id IN VARCHAR2 DEFAULT NULL,
57 poa_cm_item IN VARCHAR2 DEFAULT NULL,
58 poa_cm_comments IN VARCHAR2 DEFAULT NULL,
59 poa_cm_evaluated_by_id IN VARCHAR2 DEFAULT NULL,
60 poa_cm_evaluated_by IN VARCHAR2 DEFAULT NULL,
61 poa_cm_org_id IN VARCHAR2 DEFAULT NULL,
62 poa_cm_oper_unit_id IN VARCHAR2 DEFAULT NULL,
63 poa_cm_operating_unit IN VARCHAR2 DEFAULT NULL,
64 poa_cm_submit_type IN VARCHAR2 DEFAULT NULL,
65 poa_cm_evaluation_id IN VARCHAR2 DEFAULT NULL
66 );
67
68
69 END poa_cm_enter_scores_icx;