APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_STANDARD_OPERATIONS

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

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

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

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

Line 2197: from bom_standard_operations

2193: if (v_wljdi_std_op_code(l_d) is not null) then
2194: begin
2195: select standard_operation_id
2196: into v_wljdi_std_op_id(l_d)
2197: from bom_standard_operations
2198: where organization_id = p_org_id
2199: and operation_code = v_wljdi_std_op_code(l_d)
2200: and standard_operation_id = nvl(v_wljdi_std_op_id(l_d),standard_operation_id);
2201: exception

Line 2212: from bom_standard_operations

2208: v_wljdi_std_op_code(l_d) is null) then
2209: begin
2210: select operation_code
2211: into v_wljdi_std_op_code(l_d)
2212: from bom_standard_operations
2213: where organization_id = p_org_id
2214: and standard_operation_id = v_wljdi_std_op_id(l_d);
2215: exception
2216: when others then

Line 2240: from bom_standard_operations

2236: v_wljdi_backflush_flag(l_d),
2237: v_wljdi_op_yield_enable(l_d),
2238: v_wljdi_option_dep_flag(l_d),
2239: v_wljdi_inc_in_rollup(l_d)
2240: from bom_standard_operations
2241: where standard_operation_id = v_wljdi_std_op_id(l_d)
2242: and organization_id = p_org_id;
2243: exception
2244: when others then