1 PACKAGE PO_EMPLOYEES_SV AUTHID CURRENT_USER AS
2 /*$Header: POXEMEMS.pls 115.4 2002/11/25 23:32:36 sbull ship $*/
3 /*===========================================================================
4 FUNCTION NAME: get_employee()
5
6 DESCRIPTION: This procedure checks if the user logged into the
7 application is an employee and returns Employee
8 Information.
9
10 PARAMETERS:
11
12 DESIGN REFERENCES: POXPOMPO.doc
13
14 ALGORITHM:
15
16 NOTES:
17
18 OPEN ISSUES:
19
20 CLOSED ISSUES:
21
22 CHANGE HISTORY: Asarkar created 06/94
23 Siyer Modified 04/95
24 SIYER Modified 05/95
25 ===========================================================================*/
26
27
28 FUNCTION GET_EMPLOYEE (emp_id OUT NOCOPY number,
29 emp_name OUT NOCOPY varchar2,
30 location_id OUT NOCOPY number,
31 location_code OUT NOCOPY varchar2,
32 is_buyer OUT NOCOPY BOOLEAN,
33 emp_flag OUT NOCOPY BOOLEAN
34 )
35 RETURN BOOLEAN ;
36
37 /*===========================================================================
38 PROCEDURE NAME: online_user
39
40 DESCRIPTION: This procedure determines whether a person is an
41 online employee. It returns TRUE if employee is
42 online, and FALSE if employee is offline.
43
44 PARAMETERS: x_person_id IN NUMBER
45
46 DESIGN REFERENCES: POXDOAPP.dd
47
48 ALGORITHM: IF the person's user ID exists in the FND_USER table,
49 then the person is an online employee.
50
51 NOTES:
52
53 OPEN ISSUES:
54
55 CLOSED ISSUES:
56
57 CHANGE HISTORY: cmok 5/1 created
58 ===========================================================================*/
59
60 PROCEDURE test_online_user (x_person_id NUMBER);
61
62 FUNCTION online_user (x_person_id NUMBER) RETURN BOOLEAN;
63
64
65 /*===========================================================================
66 PROCEDURE NAME: get_employee_name
67
68 DESCRIPTION: This procedure returns the employee name for a
69 given employee id.
70
71 PARAMETERS: x_emp_id IN NUMBER
72
73 DESIGN REFERENCES: POXDOAPP.dd
74
75 ALGORITHM:
76
77 NOTES:
78
79 OPEN ISSUES:
80
81 CLOSED ISSUES:
82
83 CHANGE HISTORY: cmok 5/17 created
84 ===========================================================================*/
85
86 PROCEDURE test_get_employee_name (x_emp_id IN NUMBER);
87
88 PROCEDURE get_employee_name (x_emp_id IN NUMBER,
89 x_emp_name OUT NOCOPY VARCHAR2);
90
91
92 /*===========================================================================
93 PROCEDURE NAME: derive_employee_info()
94
95 DESCRIPTION: This procedure derives missing information about an
96 employee record based on information that is known
97 about the record.
98
99
100 PARAMETERS: p_emp_record IN OUT RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type
101
102 DESIGN REFERENCES:
103
104 ALGORITHM:
105
106 NOTES: uses dbms_sql to create WHERE clause based on the
107 p_emp_record components that have values.
108
109 OPEN ISSUES:
110
111 CLOSED ISSUES:
112
113 CHANGE HISTORY: 10/25/96 Raj Bhakta
114 ===========================================================================*/
115
116 PROCEDURE derive_employee_info(p_emp_record IN OUT NOCOPY RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type);
117
118
119 /*===========================================================================
120 PROCEDURE NAME: validate_employee_info()
121
122 DESCRIPTION: This procedure validates information about the employee
123 record and based on certain business rules returns
124 error status and error messages.
125
126
127 PARAMETERS: p_emp_record IN OUT RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type
128
129 DESIGN REFERENCES:
130
131 ALGORITHM:
132
133 NOTES: uses dbms_sql to create WHERE clause based on the
134 p_emp_record components that have values.
135
136 OPEN ISSUES:
137
138 CLOSED ISSUES:
139
140 CHANGE HISTORY: 10/25/96 Raj Bhakta
141 ===========================================================================*/
142
143 PROCEDURE validate_employee_info(p_emp_record IN OUT NOCOPY RCV_SHIPMENT_OBJECT_SV.Employee_id_record_type);
144
145 FUNCTION get_emp_name(x_person_id IN NUMBER) RETURN VARCHAR2;
146
147 END PO_EMPLOYEES_SV;