DBA Data[Home] [Help]

APPS.WSMPJUPD dependencies on BOM_OPERATION_SEQUENCES

Line 1511: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(x_from_entity_name => 'BOM_OPERATION_SEQUENCES',

1507: while (l_counter1 is not null) and
1508: (l_counter2 is not null)
1509: loop
1510: l_stmt_num := 60;
1511: FND_ATTACHED_DOCUMENTS2_PKG.copy_attachments(x_from_entity_name => 'BOM_OPERATION_SEQUENCES',
1512: x_from_pk1_value => to_char(l_op_seq_num_tbl(l_counter1)),
1513: x_to_entity_name => 'WSM_LOT_BASED_OPERATIONS',
1514: x_to_pk1_value => to_char(p_new_rj_we_id_tbl(l_counter)),
1515: x_to_pk2_value => to_char(l_op_seq_id_tbl(l_counter2)),

Line 3673: from bom_operation_sequences

3669: BEGIN
3670: -- Obtain the op seq num...
3671: SELECT operation_seq_num
3672: into l_rtg_op_seq_num
3673: from bom_operation_sequences
3674: where operation_sequence_id = p_rj_job_rec.starting_operation_seq_id;
3675:
3676: EXCEPTION
3677: WHEN NO_DATA_FOUND THEN

Line 6100: from bom_operation_sequences

6096:
6097: BEGIN
6098: select operation_seq_num
6099: into l_current_rtg_op_seq_num
6100: from bom_operation_sequences
6101: where operation_sequence_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_id ;
6102:
6103: EXCEPTION
6104: WHEN NO_DATA_FOUND THEN