APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on BOM_DEPARTMENTS

Line 38: TYPE bom_departments_record is RECORD

34: -- Notes : Note text
35: --
36: -- End of comments
37:
38: TYPE bom_departments_record is RECORD
39: (
40: Department_Id bom_departments.department_id%type,
41: Department_Code bom_departments.department_code%type,
42: Description bom_departments.description%type,

Line 40: Department_Id bom_departments.department_id%type,

36: -- End of comments
37:
38: TYPE bom_departments_record is RECORD
39: (
40: Department_Id bom_departments.department_id%type,
41: Department_Code bom_departments.department_code%type,
42: Description bom_departments.description%type,
43: Organization_Id bom_departments.organization_id%type
44:

Line 41: Department_Code bom_departments.department_code%type,

37:
38: TYPE bom_departments_record is RECORD
39: (
40: Department_Id bom_departments.department_id%type,
41: Department_Code bom_departments.department_code%type,
42: Description bom_departments.description%type,
43: Organization_Id bom_departments.organization_id%type
44:
45: );

Line 42: Description bom_departments.description%type,

38: TYPE bom_departments_record is RECORD
39: (
40: Department_Id bom_departments.department_id%type,
41: Department_Code bom_departments.department_code%type,
42: Description bom_departments.description%type,
43: Organization_Id bom_departments.organization_id%type
44:
45: );
46:

Line 43: Organization_Id bom_departments.organization_id%type

39: (
40: Department_Id bom_departments.department_id%type,
41: Department_Code bom_departments.department_code%type,
42: Description bom_departments.description%type,
43: Organization_Id bom_departments.organization_id%type
44:
45: );
46:
47: Type Bom_Departments_Table is TABLE of bom_departments_record index by binary_integer;

Line 47: Type Bom_Departments_Table is TABLE of bom_departments_record index by binary_integer;

43: Organization_Id bom_departments.organization_id%type
44:
45: );
46:
47: Type Bom_Departments_Table is TABLE of bom_departments_record index by binary_integer;
48:
49: TYPE Org_Access_Record is record
50: (
51: Organization_Id Number,

Line 324: PROCEDURE return_bom_departments

320: , p_debug_filename IN VARCHAR2 := 'EAM_WO_DEBUG.log'
321: , p_debug_file_mode IN VARCHAR2 := 'w'
322: );
323:
324: PROCEDURE return_bom_departments
325: (
326: p_organization_id NUMBER
327: ,p_user_name VARCHAR2
328: ,x_bom_departments_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.bom_departments_table

Line 328: ,x_bom_departments_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.bom_departments_table

324: PROCEDURE return_bom_departments
325: (
326: p_organization_id NUMBER
327: ,p_user_name VARCHAR2
328: ,x_bom_departments_table OUT NOCOPY EAM_LINEAR_LOCATIONS_PUB.bom_departments_table
329: );
330:
331: Procedure return_organizations
332: (