4: -- Global Variables and Constants --
5: ------------------------------------
6:
7: g_pkg_name CONSTANT VARCHAR2(30) := 'BOM_ALTERNATE_DESIGNATORS_PKG';
8: g_current_user_id NUMBER := FND_GLOBAL.User_Id;
9: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
10:
11: TYPE Bom_Alt_Desig_Rec IS RECORD
12: ( -- Columns from Bom_Alternate_Designators table
5: ------------------------------------
6:
7: g_pkg_name CONSTANT VARCHAR2(30) := 'BOM_ALTERNATE_DESIGNATORS_PKG';
8: g_current_user_id NUMBER := FND_GLOBAL.User_Id;
9: g_current_login_id NUMBER := FND_GLOBAL.Login_Id;
10:
11: TYPE Bom_Alt_Desig_Rec IS RECORD
12: ( -- Columns from Bom_Alternate_Designators table
13: Alternate_Designator_Code VARCHAR2(10)