1: PACKAGE BODY PO_GLOBAL AS
2: /* $Header: PO_GLOBAL.plb 120.1 2005/07/26 13:06:32 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GLOBAL');
1: PACKAGE BODY PO_GLOBAL AS
2: /* $Header: PO_GLOBAL.plb 120.1 2005/07/26 13:06:32 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GLOBAL');
6:
1: PACKAGE BODY PO_GLOBAL AS
2: /* $Header: PO_GLOBAL.plb 120.1 2005/07/26 13:06:32 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_GLOBAL');
6:
7: -----------------------------------------------------------------------
8: --Start of Comments
9: --Name: set_role
13: -- None
14: --Function:
15: -- Sets the role of the user for the current database session.
16: -- Role can have one of the following values:
17: -- PO_GLOBAL.g_role_BUYER : Buyer
18: -- PO_GLOBAL.g_role_CAT_ADMIN : Catalog Admin
19: -- PO_GLOBAL.g_role_SUPPLIER : Supplier
20: --Parameters:
21: --IN:
14: --Function:
15: -- Sets the role of the user for the current database session.
16: -- Role can have one of the following values:
17: -- PO_GLOBAL.g_role_BUYER : Buyer
18: -- PO_GLOBAL.g_role_CAT_ADMIN : Catalog Admin
19: -- PO_GLOBAL.g_role_SUPPLIER : Supplier
20: --Parameters:
21: --IN:
22: --p_role
15: -- Sets the role of the user for the current database session.
16: -- Role can have one of the following values:
17: -- PO_GLOBAL.g_role_BUYER : Buyer
18: -- PO_GLOBAL.g_role_CAT_ADMIN : Catalog Admin
19: -- PO_GLOBAL.g_role_SUPPLIER : Supplier
20: --Parameters:
21: --IN:
22: --p_role
23: -- role to set
81:
82: RETURN g_role;
83: END role;
84:
85: END PO_GLOBAL;