APPS.MTL_CCEOI_ACTION_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 421: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',

417: p_api_version => 0.9,
418: p_interface_rec => p_interface_rec,
419: p_message_name => 'INV_CCEOI_NO_UNSCHD_COUNTS',
420: p_error_column_name => 'UNSCHEDULED_COUNT_ENTRY',
421: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',
422: p_flags => '1$2$',
423: x_return_status => x_return_status,
424: x_msg_count => x_msg_count,
425: x_msg_data => x_msg_data);

Line 715: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',

711: p_api_version => 0.9,
712: p_interface_rec => p_interface_rec,
713: p_message_name => 'INV_CCEOI_NO_UNSCHD_COUNTS',
714: p_error_column_name => 'UNSCHEDULED_COUNT_ENTRY',
715: p_error_table_name => 'MTL_CYCLE_COUNT_HEADERS',
716: p_flags => '1$2$',
717: x_return_status => x_return_status,
718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data);

Line 1138: FROM mtl_cycle_count_headers where

1134:
1135:
1136: select next_user_count_sequence
1137: into MTL_CCEOI_VAR_PVT.G_Seq_No
1138: FROM mtl_cycle_count_headers where
1139: cycle_count_header_id = MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID;
1140:
1141:
1142: -- the following piece of code makes sure that count list sequence

Line 1167: update mtl_cycle_count_headers

1163: IF (l_debug = 1) THEN
1164: MDEBUG( 'Create New Sequence ='||to_char(MTL_CCEOI_VAR_PVT.G_Seq_No));
1165: END IF;
1166: --
1167: update mtl_cycle_count_headers
1168: set next_user_count_sequence = MTL_CCEOI_VAR_PVT.G_Seq_No + 1
1169: where cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1170: L_errorcode := 0;
1171: L_return_status := FND_API.G_RET_STS_SUCCESS ;