DBA Data[Home] [Help]

APPS.WIP_POPULATE_TEMP dependencies on WIP_COMPONENT

Line 48: SELECT round(WIP_COMPONENT.Determine_Txn_Quantity

44:
45:
46: CURSOR CDIS IS
47: --bug 7654664: rounding the transaction_quantity to inventory precision
48: SELECT round(WIP_COMPONENT.Determine_Txn_Quantity
49: (p_transaction_action_id,
50: wro.quantity_per_assembly,
51: wro.required_quantity,
52: wro.quantity_issued,

Line 92: WIP_COMPONENT.Valid_Subinventory(msinv.secondary_inventory_name,

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

Line 111: AND WIP_COMPONENT.is_valid(

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

Line 118: AND WIP_COMPONENT.meets_criteria(

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

Line 213: AND WIP_COMPONENT.is_valid(

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

Line 220: AND WIP_COMPONENT.meets_criteria(

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

Line 329: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator

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

Line 586: x_valid_subinventory_flag := WIP_COMPONENT.Valid_Subinventory

582: IF(C.subinventory_code IS NULL) THEN
583: x_valid_subinventory_flag := 'N';
584: x_valid_locator_flag := 'N';
585: ELSE
586: x_valid_subinventory_flag := WIP_COMPONENT.Valid_Subinventory
587: (C.subinventory_code,
588: C.inventory_item_id,
589: p_organization_id);
590:

Line 593: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator

589: p_organization_id);
590:
591: x_locator_id := C.inventory_location_id;
592:
593: x_valid_locator_flag := WIP_COMPONENT.Valid_Locator
594: (x_locator_id,
595: C.inventory_item_id,
596: p_organization_id,
597: C.stock_locator_control_code,