PACKAGE: APPS.WIP_WS_SKILL_CHECK_PVT

Source

1 PACKAGE WIP_WS_SKILL_CHECK_PVT AUTHID CURRENT_USER AS
2 /* $Header: wipwsscs.pls 120.0.12010000.3 2009/04/30 12:08:05 pfauzdar noship $ */
3 
4 G_PREF_ORG_ATTRIBUTE VARCHAR2(30) := 'Org';
5 G_PREF_CLOCK_ATTRIBUTE VARCHAR2(30) := 'Clock';
6 G_PREF_MOVE_ATTRIBUTE VARCHAR2(30) := 'Move';
7 G_PREF_CERTIFY_ATTRIBUTE VARCHAR2(30) := 'Certify';
8 
9 G_PREF_CLOCK_VALUE NUMBER := 1;
10 G_PREF_MOVE_VALUE NUMBER := 0;
11 G_PREF_CERTIFY_VALUE NUMBER := 0;
12 
13 G_DISABLE_CLOCK_VALIDATION CONSTANT NUMBER :=1;
14 G_ALLOW_ONLY_SKILL_OPERATORS CONSTANT NUMBER :=2;
15 G_ALLOW_ALL_OPERATORS CONSTANT NUMBER :=3;
16 
17 G_DISABLE_MOVE_VALIDATION CONSTANT NUMBER := 0;
18 G_ENABLE_MOVE_VALIDATION NUMBER := 1;
19 
20 G_DISABLE_CERTIFICATION_CHECK CONSTANT NUMBER := 0;
21 G_ENABLE_CERTIFICATION_CHECK CONSTANT NUMBER := 1;
22 
23 G_SKILL_CHECK_ENABLED CONSTANT NUMBER :=1;
24 
25 G_SKILL_VALIDATION_SUCCESS   CONSTANT NUMBER :=1;
26 G_COMPETENCE_CHECK_FAIL      CONSTANT NUMBER :=2;
27 G_CERTIFY_CHECK_FAIL         CONSTANT NUMBER :=3;
28 G_QUALIFY_CHECK_FAIL         CONSTANT NUMBER :=4;
29 G_INV_SKILL_CHECK_EMP        CONSTANT NUMBER :=5;
30 G_SKILL_VALIDATION_EXCEPTION CONSTANT NUMBER :=6;
31 G_NO_SKILL_EMP_CLOCKIN       CONSTANT NUMBER :=7;
32 
33 G_WIP_ENTITY_NAME VARCHAR2(240);
34 G_EMPLOYEE VARCHAR2(240);
35 
36 function validate_skill_for_clock_in(p_wip_entity_id   in number,
37                                      p_op_seq_num      in number,
38                                      p_emp_id          in number)
39 return number;
40 
41 procedure validate_skill_for_move_txn(p_wip_entity_id   in number,
42                                       p_organization_id in number,
43                                       p_from_op         in number,
44                                       p_to_op           in number,
45                                       p_from_step       in number,
46                                       p_to_step         in number,
47                                       p_emp_id          in number,
48                                       l_validate_skill out nocopy number,
49                                       l_move_pref      out nocopy varchar2,
50                                       l_certify_pref   out nocopy varchar2,
51                                       l_err_msg        out nocopy varchar2);
52 
53 procedure validate_skill_for_exp_move(p_wip_entity_id   in number,
54                                       p_organization_id in number,
55                                       p_op_seq_num      in number,
56                                       p_emp_id          in number,
57                                       l_validate_skill out nocopy number,
58                                       l_err_msg        out nocopy varchar2);
59 
60 END WIP_WS_SKILL_CHECK_PVT;