PACKAGE: APPS.WIP_STD_WF

Source

1 PACKAGE wip_std_wf AUTHID CURRENT_USER AS
2 /*$Header: wipwstds.pls 115.6 2002/12/12 16:04:15 rmahidha ship $ */
3 
4 
5 --  Function: Get_EmployeeLogin
6 --  Desc: Given an employee_id, returns back the user login
7 --
8 FUNCTION GetEmployeeLogin ( p_employee_id NUMBER ) return VARCHAR2;
9 
10 --  Function: GetSupplierLogin
11 --  Desc: Given an supplier_id, returns back the user login
12 --
13 FUNCTION GetSupplierLogin ( p_supplier_id NUMBER ) return VARCHAR2;
14 
15 -- Function: GetShipManagerLogin
16 -- Desc:  Finds the shipping manager id for an organization, and
17 --        then derives the shipping manager login
18 --
19 FUNCTION GetShipManagerLogin ( p_organization_id NUMBER ) return VARCHAR2;
20 
21 -- Function: GetProductionSchedLogin
22 -- Desc:  Finds the production scheduler id for an organization, and
23 --        then derives the production scheduler login
24 --
25 FUNCTION GetProductionSchedLogin ( p_organization_id NUMBER ) return VARCHAR2;
26 
27 -- Function: GetDefaultBuyerLogin
28 -- Desc:  Finds the login for the default buyer of an item in an organization
29 --        then derives the production scheduler login
30 --
31 FUNCTION GetDefaultBuyerLogin (p_organization_id	NUMBER,
32 			       p_item_id		NUMBER) return VARCHAR2;
33 
34 FUNCTION GetBuyerLogin (p_po_header_id	NUMBER, p_release_num NUMBER default NULL) return VARCHAR2;
35 
36 
37 FUNCTION GetSupplierContactLogin (p_po_header_id NUMBER) return VARCHAR2;
38 
39 
40 /* used for linking to PO webpage from notifications */
41 PROCEDURE OpenPO(p1     varchar2,
42                  p2     varchar2,
43                  p3     varchar2,
44                  p4     varchar2,
45                  p5     varchar2,
46                  p6     varchar2,
47                  p11    varchar2 default NULL);
48 
49 END wip_std_wf;