1 PACKAGE gmo_oper_cert_pub AS
2 /* $Header: GMOOPCTS.pls 120.1 2007/06/21 06:12:10 rvsingh noship $ */
3 /*#
4 * This file contains procedures for the Operator Certificate(GMO)APIs in *
5 * Oracle Process Manufacturing (OPM). Each procedure has a common set of *
6 * parameters to which API-specific parameters are appended. *
7 *************************************************************************/
8 /*
9 * @rep:scope public
10 * @rep:product GMO
11 * @rep:displayname Production Management public api's
12 * @rep:lifecycle active
13 * @rep:category BUSINESS_ENTITY PRODUCT_MANAGEMENT_API'S
14 */
15 /*================================================================================
16 Procedure
17 check_certification
18 Description
19 This procedure is used to check whether the given user is certified
20 or has competency for a given task.
21 Parameters
22 p_header_id (O) The header_id used by the inventory transaction manager.
23 p_table (O) Table to process by Transaction Manager
24 1 - temp table
25 2 - interface table
26 x_return_status outcome of the API call
27 S - Success
28 E - Error
29 U - Unexpected Error
30 p_commit Indicates whether to commit.
31 'T' (FND_API.G_TRUE) - to commit work
32 'F' (FND_API.G_FALSE) - Not to commit work
33 This is defaulted 'F'
34 Return 0 = not certified
35 1 = certified
36 -1 = No over ride allowed
37 ================================================================================*/
38
39
40 FUNCTION check_certification(
41 p_user_id IN NUMBER
42 ,p_org_id IN NUMBER
43 ,p_object_id IN NUMBER DEFAULT NULL
44 ,p_object_type IN NUMBER DEFAULT NULL
45 ,p_eff_date IN DATE
46 ,x_return_status OUT NOCOPY VARCHAR2) RETURN NUMBER;
47
48 PROCEDURE required_certification(
49 p_user_id IN NUMBER
50 ,p_org_id IN NUMBER
51 ,p_header_id IN NUMBER
52 ,p_operator_certificate_id IN NUMBER
53 ,p_eff_date IN DATE
54 ,x_return_status OUT NOCOPY VARCHAR2) ;
55
56 Procedure Update_erecord(
57 p_ERECORD_ID IN NUMBER
58 ,p_Operator_certificate_id IN NUMBER
59 ,p_EVENT_KEY IN VARCHAR2
60 ,p_EVENT_NAME IN VARCHAR2
61 ,x_return_status OUT NOCOPY VARCHAR2);
62
63 FUNCTION check_certification(
64 p_user_id IN NUMBER
65 ,p_org_id IN NUMBER
66 ,p_object_id IN NUMBER DEFAULT NULL
67 ,p_object_type IN NUMBER DEFAULT NULL
68 ,p_eff_date IN DATE) RETURN NUMBER;
69
70
71 /*================================================================================
72 Procedure
73 update_cert_record
74 Description
75 This procedure is used for acknowledging the Operator Certification module to change the Status
76 to S and update the E-record ID once the Transaction is successful.
77 Parameters
78 p_Operator_certificate_id The header_id used by the inventory transaction manager.
79 p_EVENT_KEY Event Key
80 p_EVENT_NAME Event Name
81 p_ERECORD_ID E-Record ID
82 p_user_key_label_token User Key Label
83 p_user_key_value User Key Value
84 p_transaction_id Transaction ID
85 x_return_status outcome of the API call
86 S - Success
87 E - Error
88 U - Unexpected Error
89 ================================================================================*/
90
91 procedure update_cert_record(p_Operator_certificate_id IN NUMBER
92 ,p_EVENT_KEY IN VARCHAR2
93 ,p_EVENT_NAME IN VARCHAR2
94 ,p_ERECORD_ID IN NUMBER
95 ,p_user_key_label_token IN VARCHAR2
96 ,p_user_key_value IN VARCHAR2
97 ,p_transaction_id IN VARCHAR2
98 ,x_return_status OUT NOCOPY VARCHAR2
99 );
100
101
102
103 PROCEDURE cert_details (
104 p_operator_CERTIFICATE_ID IN OUT NOCOPY NUMBER
105 ,p_HEADER_ID IN NUMBER
106 ,p_TRANSACTION_ID IN VARCHAR2
107 ,p_USER_ID IN NUMBER
108 ,p_comments IN VARCHAR2
109 ,p_OVERRIDER_ID IN NUMBER
110 ,p_User_key_label_product IN VARCHAR2
111 ,p_User_key_label_token IN VARCHAR2
112 ,p_User_key_value IN VARCHAR2
113 ,p_Erecord_id IN NUMBER
114 ,p_Trans_object_id IN NUMBER
115 ,p_STATUS IN VARCHAR2
116 ,p_event_name IN VARCHAR2
117 ,p_event_key IN VARCHAR2
118 ,p_eff_date IN DATE
119 ,p_CREATION_DATE IN DATE
120 ,p_CREATED_BY IN NUMBER
121 ,p_LAST_UPDATE_DATE IN DATE
122 ,p_LAST_UPDATED_BY IN NUMBER
123 ,p_LAST_UPDATE_LOGIN IN NUMBER
124 ,x_return_Status OUT NOCOPY VARCHAR2 );
125
126 END gmo_oper_cert_pub;