DBA Data[Home] [Help]

APPS.WIP_POPULATE_TEMP dependencies on WIP_COMPONENT

Line 47: SELECT WIP_COMPONENT.Determine_Txn_Quantity

43: l_include_yield NUMBER; /* ER 4369064: Component Yield Enhancement */
44:
45:
46: CURSOR CDIS IS
47: SELECT WIP_COMPONENT.Determine_Txn_Quantity
48: (p_transaction_action_id,
49: wro.quantity_per_assembly,
50: wro.required_quantity,
51: wro.quantity_issued,

Line 90: WIP_COMPONENT.Valid_Subinventory(msinv.secondary_inventory_name,

86: msi.auto_serial_alpha_prefix,
87: mil.inventory_location_id,
88: mil.disable_date locator_disable_date,
89: mp.stock_locator_control_code,
90: WIP_COMPONENT.Valid_Subinventory(msinv.secondary_inventory_name,
91: msi.inventory_item_id,
92: p_organization_id)
93: valid_subinventory_flag,
94: mil.project_id,

Line 109: AND WIP_COMPONENT.is_valid(

105: wip_discrete_jobs wdj,
106: wip_requirement_operations wro
107: WHERE wro.wip_entity_id = p_wip_entity_id
108: AND wro.organization_id = p_organization_id
109: AND WIP_COMPONENT.is_valid(
110: p_transaction_action_id,
111: wro.wip_supply_type,
112: wro.required_quantity,
113: wro.quantity_issued,

Line 116: AND WIP_COMPONENT.meets_criteria(

112: wro.required_quantity,
113: wro.quantity_issued,
114: p_assembly_quantity,
115: p_entity_type) = WIP_CONSTANTS.YES
116: AND WIP_COMPONENT.meets_criteria(
117: wro.operation_seq_num,
118: p_operation_seq_num,
119: wro.department_id,
120: p_department_id,

Line 210: AND WIP_COMPONENT.is_valid(

206: --AND bcd1.calendar_date(+) = trunc(wro.date_required)
207: AND trunc(bcd1.calendar_date(+)) = trunc(wro.date_required)
208: AND bcd1.next_seq_num(+) < p_next_seq_num + p_repetitive_days
209: AND bcd1.next_seq_num + wrs.processing_work_days > p_next_seq_num
210: AND WIP_COMPONENT.is_valid(
211: p_transaction_action_id,
212: wro.wip_supply_type,
213: wro.required_quantity,
214: wro.quantity_issued,

Line 217: AND WIP_COMPONENT.meets_criteria(

213: wro.required_quantity,
214: wro.quantity_issued,
215: NULL,
216: p_entity_type) = WIP_CONSTANTS.YES
217: AND WIP_COMPONENT.meets_criteria(
218: wro.operation_seq_num,
219: p_operation_seq_num,
220: wro.department_id,
221: p_department_id,

Line 326: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator

322:
323: x_locator_id := C.inventory_location_id;
324: /* Fix for Bug# 2149033. Added x_locator_id condition in if condition */
325: IF(C.subinventory_code IS NOT NULL) and (x_locator_id IS NOT NULL) THEN
326: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator
327: (x_locator_id,
328: C.inventory_item_id,
329: p_organization_id,
330: C.stock_locator_control_code,

Line 582: x_valid_subinventory_flag := WIP_COMPONENT.Valid_Subinventory

578: IF(C.subinventory_code IS NULL) THEN
579: x_valid_subinventory_flag := 'N';
580: x_valid_locator_flag := 'N';
581: ELSE
582: x_valid_subinventory_flag := WIP_COMPONENT.Valid_Subinventory
583: (C.subinventory_code,
584: C.inventory_item_id,
585: p_organization_id);
586:

Line 589: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator

585: p_organization_id);
586:
587: x_locator_id := C.inventory_location_id;
588:
589: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator
590: (x_locator_id,
591: C.inventory_item_id,
592: p_organization_id,
593: C.stock_locator_control_code,