DBA Data[Home] [Help]

APPS.WIP_SCHEDULER dependencies on BOM_OPERATION_SEQUENCES

Line 38: AND fnd.entity_name = 'BOM_OPERATION_SEQUENCES');

34: AND EXISTS
35: (SELECT fnd.pk1_value
36: FROM fnd_attached_documents fnd
37: WHERE fnd.pk1_value = to_char(ops.operation_sequence_id)
38: AND fnd.entity_name = 'BOM_OPERATION_SEQUENCES');
39: l_params wip_logger.param_tbl_t;
40: l_returnStatus VARCHAR(1);
41: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
42: BEGIN

Line 160: FROM BOM_OPERATION_SEQUENCES SEQ

156: SEQ.ATTRIBUTE12,
157: SEQ.ATTRIBUTE13,
158: SEQ.ATTRIBUTE14,
159: SEQ.ATTRIBUTE15
160: FROM BOM_OPERATION_SEQUENCES SEQ
161: WHERE SEQ.ROUTING_SEQUENCE_ID = X_Routing_Seq
162: /* %cfm */
163: AND NVL(SEQ.OPERATION_TYPE, 1) = 1
164: /* %/cfm */

Line 302: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',

298:
299: FOR cur_rec IN wip_op_inst LOOP
300: IF (X_Repetitive_Schedule_Id IS NULL) THEN
301: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
302: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
303: X_FROM_PK1_VALUE => to_char(cur_rec.operation_sequence_id),
304: X_TO_ENTITY_NAME => 'WIP_DISCRETE_OPERATIONS',
305: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
306: X_TO_PK2_VALUE => to_char(cur_rec.operation_seq_num),

Line 316: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',

312: X_REQUEST_ID => p_req_id);
313:
314: ELSE
315: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(
316: X_FROM_ENTITY_NAME => 'BOM_OPERATION_SEQUENCES',
317: X_FROM_PK1_VALUE => to_char(cur_rec.operation_sequence_id),
318: X_TO_ENTITY_NAME => 'WIP_REPETITIVE_OPERATIONS',
319: X_TO_PK1_VALUE => to_char(X_Wip_Entity_Id),
320: X_TO_PK2_VALUE => to_char(cur_rec.operation_seq_num),