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 3679: from bom_operation_sequences

3675: BEGIN
3676: -- Obtain the op seq num...
3677: SELECT operation_seq_num
3678: into l_rtg_op_seq_num
3679: from bom_operation_sequences
3680: where operation_sequence_id = p_rj_job_rec.starting_operation_seq_id;
3681:
3682: EXCEPTION
3683: WHEN NO_DATA_FOUND THEN

Line 6164: from bom_operation_sequences

6160:
6161: BEGIN
6162: select operation_seq_num
6163: into l_current_rtg_op_seq_num
6164: from bom_operation_sequences
6165: where operation_sequence_id = p_wltx_starting_jobs_tbl(l_rep_sj_index).operation_seq_id ;
6166:
6167: EXCEPTION
6168: WHEN NO_DATA_FOUND THEN