APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_STANDARD_OPERATIONS

Line 447: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;

443: type t_wljdi_quantity_per_assembly is table of wsm_lot_job_dtl_interface.quantity_per_assembly %type;
444: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
445: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
446: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
447: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
448: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
449:
450: /*Added below two types for bugfix:7248992 */
451: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;

Line 448: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;

444: type t_wljdi_supply_subinventory is table of wsm_lot_job_dtl_interface.supply_subinventory %type;
445: type t_wljdi_supply_locator_id is table of wsm_lot_job_dtl_interface.supply_locator_id %type;
446: type t_wljdi_applied_resource_units is table of wsm_lot_job_dtl_interface.applied_resource_units %type;
447: type t_desc is table of bom_standard_operations.operation_description%type index by binary_integer;
448: type t_op_code is table of bom_standard_operations.operation_code%type index by binary_integer;
449:
450: /*Added below two types for bugfix:7248992 */
451: type t_wljdi_cum_yield is table of wsm_lot_job_dtl_interface.cumulative_yield %type;
452: type t_wljdi_rev_cum_yield is table of wsm_lot_job_dtl_interface.reverse_cumulative_yield %type;

Line 2202: from bom_standard_operations

2198: if (v_wljdi_std_op_code(l_d) is not null) then
2199: begin
2200: select standard_operation_id
2201: into v_wljdi_std_op_id(l_d)
2202: from bom_standard_operations
2203: where organization_id = p_org_id
2204: and operation_code = v_wljdi_std_op_code(l_d)
2205: and standard_operation_id = nvl(v_wljdi_std_op_id(l_d),standard_operation_id);
2206: exception

Line 2217: from bom_standard_operations

2213: v_wljdi_std_op_code(l_d) is null) then
2214: begin
2215: select operation_code
2216: into v_wljdi_std_op_code(l_d)
2217: from bom_standard_operations
2218: where organization_id = p_org_id
2219: and standard_operation_id = v_wljdi_std_op_id(l_d);
2220: exception
2221: when others then

Line 2245: from bom_standard_operations

2241: v_wljdi_backflush_flag(l_d),
2242: v_wljdi_op_yield_enable(l_d),
2243: v_wljdi_option_dep_flag(l_d),
2244: v_wljdi_inc_in_rollup(l_d)
2245: from bom_standard_operations
2246: where standard_operation_id = v_wljdi_std_op_id(l_d)
2247: and organization_id = p_org_id;
2248: exception
2249: when others then