APPS.EAM_LINEAR_LOCATIONS_PUB dependencies on BOM_DEPARTMENTS

Line 1118: procedure return_bom_departments

1114: ,p_data => x_msg_data);
1115:
1116: end create_eam_wo;
1117:
1118: procedure return_bom_departments
1119: ( p_organization_id in number
1120: ,p_user_name in VARCHAR2
1121: ,x_bom_departments_table out nocopy eam_linear_locations_pub.bom_departments_table
1122: ) is

Line 1121: ,x_bom_departments_table out nocopy eam_linear_locations_pub.bom_departments_table

1117:
1118: procedure return_bom_departments
1119: ( p_organization_id in number
1120: ,p_user_name in VARCHAR2
1121: ,x_bom_departments_table out nocopy eam_linear_locations_pub.bom_departments_table
1122: ) is
1123: l_user_id number;
1124: l_resp_id number;
1125: l_resp_appl_id number;

Line 1130: from bom_departments

1126: l_dept_index binary_integer;
1127:
1128: cursor dept_cursor (p_organization_id in number) is
1129: select department_id, department_code,description,organization_id
1130: from bom_departments
1131: where organization_id = p_organization_id
1132: and nvl(disable_date, sysdate+1) >= sysdate;
1133:
1134: begin

Line 1150: x_bom_departments_table(l_dept_index).Department_Id := l_bom_dept_row.department_id;

1146: */
1147: l_dept_index := 1;
1148:
1149: FOR l_bom_dept_row in dept_cursor(p_organization_id) LOOP
1150: x_bom_departments_table(l_dept_index).Department_Id := l_bom_dept_row.department_id;
1151: x_bom_departments_table(l_dept_index).Department_Code := l_bom_dept_row.department_Code;
1152: x_bom_departments_table(l_dept_index).Description := l_bom_dept_row.Description;
1153: x_bom_departments_table(l_dept_index).Organization_Id := l_bom_dept_row.Organization_Id;
1154: l_dept_index := l_dept_index + 1;

Line 1151: x_bom_departments_table(l_dept_index).Department_Code := l_bom_dept_row.department_Code;

1147: l_dept_index := 1;
1148:
1149: FOR l_bom_dept_row in dept_cursor(p_organization_id) LOOP
1150: x_bom_departments_table(l_dept_index).Department_Id := l_bom_dept_row.department_id;
1151: x_bom_departments_table(l_dept_index).Department_Code := l_bom_dept_row.department_Code;
1152: x_bom_departments_table(l_dept_index).Description := l_bom_dept_row.Description;
1153: x_bom_departments_table(l_dept_index).Organization_Id := l_bom_dept_row.Organization_Id;
1154: l_dept_index := l_dept_index + 1;
1155: END LOOP;

Line 1152: x_bom_departments_table(l_dept_index).Description := l_bom_dept_row.Description;

1148:
1149: FOR l_bom_dept_row in dept_cursor(p_organization_id) LOOP
1150: x_bom_departments_table(l_dept_index).Department_Id := l_bom_dept_row.department_id;
1151: x_bom_departments_table(l_dept_index).Department_Code := l_bom_dept_row.department_Code;
1152: x_bom_departments_table(l_dept_index).Description := l_bom_dept_row.Description;
1153: x_bom_departments_table(l_dept_index).Organization_Id := l_bom_dept_row.Organization_Id;
1154: l_dept_index := l_dept_index + 1;
1155: END LOOP;
1156: end if;

Line 1153: x_bom_departments_table(l_dept_index).Organization_Id := l_bom_dept_row.Organization_Id;

1149: FOR l_bom_dept_row in dept_cursor(p_organization_id) LOOP
1150: x_bom_departments_table(l_dept_index).Department_Id := l_bom_dept_row.department_id;
1151: x_bom_departments_table(l_dept_index).Department_Code := l_bom_dept_row.department_Code;
1152: x_bom_departments_table(l_dept_index).Description := l_bom_dept_row.Description;
1153: x_bom_departments_table(l_dept_index).Organization_Id := l_bom_dept_row.Organization_Id;
1154: l_dept_index := l_dept_index + 1;
1155: END LOOP;
1156: end if;
1157:

Line 1158: end return_bom_departments;

1154: l_dept_index := l_dept_index + 1;
1155: END LOOP;
1156: end if;
1157:
1158: end return_bom_departments;
1159:
1160: Procedure return_organizations
1161: (
1162: p_user_name VARCHAR2

Line 1227: bom_departments bd

1223: ml2.meaning work_request_type, wewr.phone_number phone_number,
1224: wewr.e_mail e_mail, wewr.contact_preference contact_preference
1225: from org_access_view oav, mfg_lookups ml, mfg_lookups ml1,
1226: mfg_lookups ml2, wip_eam_work_requests wewr, wip_entities we,
1227: bom_departments bd
1228: where wewr.work_request_id = p_work_request_id
1229: and oav.organization_id = wewr.organization_id
1230: and oav.resp_application_id = appl
1231: and oav.responsibility_id = resp